Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing
I need to be able to compare a column of values on one tab with a column of values in another tab. I was able to do this before using a function within the cell itself but I can not remember how
Any ideas on how to do this? Any help would be appreciated Thanks Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing
in the first sheet in B1
=Countif(A1,Sheet2!$A:$A) then drag fill down the column. as an example. -- Regards, Tom Ogilvy "Kirk" wrote in message ... I need to be able to compare a column of values on one tab with a column of values in another tab. I was able to do this before using a function within the cell itself but I can not remember how. Any ideas on how to do this? Any help would be appreciated. Thanks. Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing | Excel Discussion (Misc queries) | |||
comparing | Excel Worksheet Functions | |||
Comparing more than two | Excel Worksheet Functions | |||
Comparing Data | Excel Worksheet Functions | |||
Comparing times.. | Excel Worksheet Functions |