Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi! I am trying to compare multiple column in a worksheet to find
common component in all the columns and what is unique to a particular column only. And list the results/finding in adj column. What i am trying to accomplish is something as below. BEFORE Sheet1 Sheet2 Sheet3 Column2 Column2 Column2 02-1234-12 07-1234-12 02-1234-12 04-1234-12 03-1234-12 02-1234-12 05-1234-12 02-1234-12 06-1234-34 AFTER Common to all Unique to sheet1 Unique to Sheet2 02-1234-12 05-1234-12 07-1234-12 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to compare two column of data and sort them out according | New Users to Excel | |||
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) |