Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding unique data between 2 columns
I have a spread sheet as such:
column 1 column 2 a a b b c e d What I need to do is compare the 2 columns and figure out which entries are unique to both columns and which are only in column1 or column 2. The data will be alphanumeric. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you sum the last 5 columns of data from a range of data | New Users to Excel | |||
Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |