Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 2 columns of data. Both should ultimately have identical data,
but both have extranious data I need to separate. These lists will be 300+ long, so by hand is taking forever. Example: Column A Column B 12345 12344 12346 12345 12347 12346 12348 12347 12349 12349 I need a way to extract the 12344 from column B since it is not in A, and 12348 from A since it is not in B. They do not have the same number of entries. Any ideas? Thanks sooooo much in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching and aranging data form two sources | Excel Worksheet Functions | |||
Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |