Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Comparing columns
Hi,
Can somebody please advise me on how to do the following in Excel: Compare a set of values (text) in column A with a set of values (text) in column B (no necessarily in line with each other) and output any differences to any of the following: - Column C - Another worksheet in the same workbook - a text file Thanks Andy |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Comparing columns
Hi, When you say you want to see the output (wherever it is to go) - what
output are you looking for? If the data in two columns is to be cross matched, you will possibly end up with a number of scenarios of matches, non-matches on same row, different rows and possibly multiple rows. What should column C contain? -- Cheers Nigel "Andy" wrote in message .co.uk... Hi, Can somebody please advise me on how to do the following in Excel: Compare a set of values (text) in column A with a set of values (text) in column B (no necessarily in line with each other) and output any differences to any of the following: - Column C - Another worksheet in the same workbook - a text file Thanks Andy |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Comparing columns
Hi Andy,
See Chip Pearson's Duplicates and Unique Values page. http://www.cpearson.com/excel/duplic...tingDuplicates Look in particular at the last two sections on that page. --- Regards, Norman "Andy" wrote in message .co.uk... Hi, Can somebody please advise me on how to do the following in Excel: Compare a set of values (text) in column A with a set of values (text) in column B (no necessarily in line with each other) and output any differences to any of the following: - Column C - Another worksheet in the same workbook - a text file Thanks Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing columns | Excel Worksheet Functions | |||
comparing two columns | Excel Worksheet Functions | |||
Comparing two columns | Excel Worksheet Functions | |||
Comparing Columns to each other | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) |