Match function or other to compare columns

[lonelyrobot99]

I am trying to compare two columns to find the unique numbers in the 2nd column. For example I might want to compare A1 through A25 to B1 through B25. Is there a match function or other function that will highlight or otherwise show only the unique numbers in the B column as compared to the A column?

Any help would be appreciated.

Thanks.

 

[T. Valko]

I am trying to compare two columns to find the unique numbers in the 2nd column. For example I might want to compare A1 through A25 to B1 through B25. Is there a match function or other function that will highlight or otherwise show only the unique numbers in the B column as compared to the A column?

Any help would be appreciated.

Thanks.

One way...

Enter this formula in C1 and copy down to C25:

=IF(COUNT(MATCH(B1,A$1:A$25,0)),"","Unique")

Numbers that appear in column B but not in column A will be labled as "Unique".

 

[mirabeau]

I am trying to compare two columns to find the unique numbers in the 2nd column. For example I might want to compare A1 through A25 to B1 through B25. Is there a match function or other function that will highlight or otherwise show only the unique numbers in the B column as compared to the A column?

Any help would be appreciated.

Thanks.

If you've got 100,000 or so rows you can do it very fast with VBA, but I guess you don't ...

 

[lonelyrobot99]

Thanks T. Valko that helps, I am playing around with the formula and I am trying to figure out if there is a way to compare multiple columns for unique numbers. For example if I wanted to find all the unique numbers in D1 through D25 as compared to both A1 through A25 and B1 through B25. Do you know how to do this?

 

[T. Valko]

Thanks T. Valko that helps, I am playing around with the formula and I am trying to figure out if there is a way to compare multiple columns for unique numbers. For example if I wanted to find all the unique numbers in D1 through D25 as compared to both A1 through A25 and B1 through B25. Do you know how to do this?

With a bit of a tweak...

=IF(COUNTIF(A$1:B$25,D1),"","Unique")

 

[lonelyrobot99]

With a bit of a tweak...

=IF(COUNTIF(A$1:B$25,D1),"","Unique")

It works great. Thanks again.

 

[T. Valko]

It works great. Thanks again.

You're welcome. Thanks for the feedback!