excel compare formula

April 1, 2010 at 01:25:56
Specs: Windows XP
In ms excel i want to compare a element in A column with all the elements in B column(This column contains duplicate values too) and i need to know that element is present in that column r not.
For example:
20 15
30 40
40 10
50 80
60 84
now i want to know 40 is present in entire B column r not. like that i want to know for all the elements in column A


See More: excel compare formula

Report •

April 1, 2010 at 04:43:57
You could use Conditional Formatting with this Formula:


For Excel 2003:

Select all of the values in Column A and Choose Format...Conditional Format...Formula Is

Pick a pattern color.

If the value in A is also in B, the cell will turn that color.

Report •
Related Solutions

Ask Question