Compare two columns
 

Please help...

I have a really big spreadsheet and would like to find all the unmatched
information when comparing two columns in a spreadsheet. Is there any
formula or functions to perform this checking, or is there any methods
suggested?

Example:
Info listed In column A: red, blue, green
Info listed in column B: blue, violet, black, yellow
Result (unmatched info) after comparing column B to column A: violet, black
and yellow

Use this formula in a helper column on the right:

=COUNTIF($A$1:$A$1000,B1)

and copy this down. Adjust ranges to suit, of course. Then Data/AutoFilter on
that column for values of 0.

On Fri, 3 Dec 2004 15:49:05 -0800, "Need Helper" <Need
wrote:

Please help...

I have a really big spreadsheet and would like to find all the unmatched
information when comparing two columns in a spreadsheet. Is there any
formula or functions to perform this checking, or is there any methods
suggested?

Example:
Info listed In column A: red, blue, green
Info listed in column B: blue, violet, black, yellow
Result (unmatched info) after comparing column B to column A: violet, black
and yellow

=if(A1=B1,0,1)



"Need Helper" <Need wrote in message
...
Please help...

I have a really big spreadsheet and would like to find all the unmatched
information when comparing two columns in a spreadsheet. Is there any
formula or functions to perform this checking, or is there any methods
suggested?

Example:
Info listed In column A: red, blue, green
Info listed in column B: blue, violet, black, yellow
Result (unmatched info) after comparing column B to column A: violet,
black
and yellow

C1, copied down:

=INDEX(B:B,SMALL(IF(COUNTIF($A$1:$A$3,$B$1:$B$4)=0 ,ROW($B$1:$B$4)),ROW()-
ROW($C$1)+1))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
"Need Helper" <Need wrote:

Please help...

I have a really big spreadsheet and would like to find all the unmatched
information when comparing two columns in a spreadsheet. Is there any
formula or functions to perform this checking, or is there any methods
suggested?

Example:
Info listed In column A: red, blue, green
Info listed in column B: blue, violet, black, yellow
Result (unmatched info) after comparing column B to column A: violet, black
and yellow