| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare 2 columns
Using Excel 2003, need to compare column B on spreadsheet 1 to column C on
spreadsheet 2 and get results if a match is found. In column B the name Betty appears, I want to know if it appears anywhere in column C on the other spreadsheet. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare 2 columns
Something like this maybe:
=IF(COUNTIF(Sheet2!$C$1:$C$8,B1)0,B1 & " Found on Sheet2!","") -- Kevin Vaughn "BettysAnswer" wrote: Using Excel 2003, need to compare column B on spreadsheet 1 to column C on spreadsheet 2 and get results if a match is found. In column B the name Betty appears, I want to know if it appears anywhere in column C on the other spreadsheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
| Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
| Conditional Format ... Compare Columns? | Excel Discussion (Misc queries) | |||
| how do I compare columns in two different workbooks? | Excel Discussion (Misc queries) | |||
Linear Mode
