Compare numbers in two columns in Excel
Solved/Closed
rypton
-
Mar 26, 2010 at 09:45 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 26, 2010 at 10:51 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 26, 2010 at 10:51 AM
Related:
- Compare numbers in two columns in Excel
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- How to change date format in excel - Guide
- Convert numbers to words in excel - Guide
- Screenshot in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Mar 26, 2010 at 10:51 AM
Mar 26, 2010 at 10:51 AM
well you can add in column C countif formula. Presuming your data starts at row 2
In C2 you can write
=COUNTIF(B:B,A2)
It will tell you how many time the value A2 appeared in column B
You can drag this formula down to the last data row
In C2 you can write
=COUNTIF(B:B,A2)
It will tell you how many time the value A2 appeared in column B
You can drag this formula down to the last data row