|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-13-2007, 09:23 AM
|
|||
|
|||
Problem with Data
I have a spreadsheet with 2 columns, A and B both with text. Some of the data are the same in both columns. I would like to take the text that is different from column A from that in column B and put that data into column C. Basically I need to filter out the same information from both columns and determine what data is different between the two columns...
Did this make sense?? It sounds simple enough, but I can't seem to get it to work. Any help would be GREATLY appreciated! jim 
|
|
#2
08-13-2007, 10:02 AM
|
||||
|
||||
|
You may need 2 formulas in 2 separate columns to get unique items when comparing 2 lists.
in C1, =IF(ISNA(MATCH($A1,$B$1:$B$100,0)),$A1,"") copied down in D1, =IF(ISNA(MATCH($B1,$A$1:$A$100,0)),$B1,"") copied down The first lists the elements in A that are not in B and the second lists the elements in B that are not in A... adjust the ranges to suit.
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#3
08-15-2007, 03:33 PM
|
|||
|
|||
|
That got it. I just changed the cell B100 or A100 to the whole column!
Thanks a bunch for your helP!
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
