How to Compare Two Columns in Excel

-

There are many ways for comparing two columns on Excel. You can manually go through them, or a formula with conditional formatting can be used. In case the columns are separated into different worksheets, then you can see them next to each other. You can follow these ways to compare two columns in Excel.


Steps for Compaing Two Columns in Microsoft Excel
•    You need to bookmark the cell on the upper side, which is titled as the A1 given in the column located in the Sheet1.
•    Now, you have to start adding this formula  to the column “A1 cell: ‘=IF(Sheet1!A1<> Sheet2!A1, “Sheet1:”&Sheet1!A1&” vs. Sheet2:”&Sheet2!A1, “”)’
•    Pull the formula on the downward direction to each column for the cells which you wish to compare two columns in Excel.
•    In the result, the cells which are not original will be bookmarked in both of the columns that you are comparing with each other.
•    The comparison you have made will be bookmarked as Sheet1 vs Sheet2.
•    The differences will be included in the Difference1 section.

Steps for Comparing Two Columns for Differences in Microsoft Excel
•    Go to a fresh sheet in Microsoft Excel.
•    Bookmark the cell in the given columns which you want to compare.
•    You need to start adding  ‘=IF(Sheet1!A1<> Sheet2!A1, “Sheet1:”&Sheet1!A1&” vs Sheet2:”&Sheet2!A1, “”)’
•    Pull the formula to the downward direction on the webpage to get multiple cells which include in the columns being compared.
•    You need to bookmark the differences like Sheet1 vs Sheet 2, Difference1, etc. into the cell wherein you have made the comparison.

Steps for Comparing Two Sheets in Microsoft Excel
•    Go to the sheet in which you want the duplicates highlighted.
•    After that, choose the cell which is on the top of the sheet in Microsoft Excel.
•    Click on the Control + Shift +End keys together.
•    Press on the Home option and after that, choose the Conditional Formatting option.
•    Choose the New Rule option.
•    Enter ‘=A1<>Sheet2!A1’ in the prompt box.
•    Now, start comparing A1 Sheet1 with the A1 Sheet 2.
•    Choose the format which you want to show.
•    After that, press on the OK button.

Steps for Comparing Two Workbooks in Microsoft Excel
•    Press on the View Side By Side option.
•    Choose the View option.
•    Choose the Arrange All option.
•    After that, choose the Vertical option so that you can easily compare two workbooks in Microsoft Excel

Steps for Comparing Conditional Formatting in Microsoft Excel
•    Go to the Excel sheet, which includes the data you wish to format.
•    Bookmark the cells, which includes the data you wish to format.
•    Choose the Home menu and after that, press on the Conditional Formatting option.
•    Choose a Rule Set option.
•    Make a new rule set by pressing on the New Rule option.
•    Now, you have to type the parameters which should be higher than a hundred.
•    Choose the format on which you wish to show the results.
•    After that, choose the OK option.

Edward Lewis  is a Microsoft Office expert and has been working in the technical industry since 2002. As a technical expert, Edward has written technical blogs, manuals, white papers, and reviews for many websites such as office.com/setup.

Source : How to Compare Two Columns in Excel


Comments

Post a Comment

Popular posts from this blog

How to Hide Bookmarks in Your Browser

-
Image
You can hide the bookmarks box with only a few clicks. But this procedure depends on the internet browser you are currently using on your device. Here’s how to hide bookmarks in your web browser. Steps to Hide Bookmarks in Google Chrome •    Go to the Google Chrome browsing application. •    Tap on the “More” symbol, and it resembles three vertical dots and is located on the upper right-hand side of the display. •    Now, you will get the pull-down list on the screen. •    Press on the Bookmarks button, or move the mouse cursor above it. •    You will get a new window on display. •    Search for the “Show Bookmarks bar” option. •    You will see a checkmark near the Show bookmarks bar option. •    Press on the Show bookmarks bar. •    Now, the bookmarks taskbar will stop showing on the screen. •    In case you...
Read more

This is How You Can Download YouTube Shorts

-
Image
  YouTube shorts is the same thing as TikTok and also Instagram Reels, where the videos are short, and also attention-grabbing are fun. So, there can be different reasons for downloading YouTube shorts. For example, if you have deleted the original video from your phone or must have forgotten the password of your channel. In such a case, you still have the option to download YouTube Shorts videos without logging in to the account. How to download videos from YouTube Shorts? Download your own YouTube shorts. You have to open the YouTube Studio on your system to download your own YouTube Shorts video. Firstly, log in to the YouTube account where the video is posted. You will see the Content tab on the left side; click on it. When you do so, all your videos, including regular and Shorts, will appear. Navigate the mouse over to the video you want to download and click the three-dot icon. From the menu, select Download. Download other’s Shorts videos There is a native way through which ...
Read more

Create The Best Social Media Content Calendar

-
Image
Every success story always works on a pre-decided planned path. This mapping and plotting require time and effort, but it binds all blocks together to create a clear road ahead. This is what a content calendar does for a smart social marketing person. A social media content calendar as a strategy helps to build and maintain credible, consistent, and healthy social media activities for the brand.  The Need Of A Social Media Content Calendar No matter how underrated the poor calendar is, the benefits of creating one for your social media strategy are magnificent. It just makes your upcoming tasks and processes more manageable and organized. It’s A Great Time Saver Who doesn’t want some extra time in the limited 24-hour schedule? However, it sounds next to impossible to save a few minutes when you are a social media marketing professional. Curating an effective strategy and moving towards it requires effort, dedication, and an eye for details. However, something is there th...
Read more