| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare data in two columns
I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in one column that do not match with the data in the other |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare data in two columns
Match(B1,A:A,0)
"excellearn2006" wrote: I have two columns of similar looking data. Some of the values may match, while the other may not. Is there a formula for me to find out the data in one column that do not match with the data in the other |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare data in two columns
Let's say I have 10 records for column A and 20 records for column B. What if
I wanted to list all the records in column B that do not match with column A- in column C. "salut" wrote: Match(B1,A:A,0) "excellearn2006" wrote: I have two columns of similar looking data. Some of the values may match, while the other may not. Is there a formula for me to find out the data in one column that do not match with the data in the other |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort or compare data from 2 different spreadsheet columns | New Users to Excel | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
