compare two columns
 

I need to compare two columns of numbers and return what doesn't match. What
formula would I use?

compare two columns
 

Assuming data in Columns A & B with the formula in Column C:

=IF(A1<B1,"No Match","")

or if you prefer a True/False

=IF(A1<B1,False,True)

Adjust column and rows as needed and copy down as far as necessary.

--
Kevin Backmann


"Theresa" wrote:

I need to compare two columns of numbers and return what doesn't match. What
formula would I use?

compare two columns
 

=IF(A2=B2,"Match","Doesn't match") and copy down.
--
David Biddulph

"Theresa" wrote in message
...
I need to compare two columns of numbers and return what doesn't match.
What
formula would I use?

compare two columns
 

If you want to see if any of the numbers in column A match with any of
the numbers in column B, then put this in C1:

=IF(ISNA(MATCH(A1,B:B,0)),"No match","")

Copy this down as far as necessary to cover your numbers.

Hope this helps.

Pete

On Apr 11, 9:23*pm, Theresa wrote:
I need to compare two columns of numbers and return what doesn't match. *What
formula would I use?

compare two columns
 

Thanks Pete, works great!

"Pete_UK" wrote:

If you want to see if any of the numbers in column A match with any of
the numbers in column B, then put this in C1:

=IF(ISNA(MATCH(A1,B:B,0)),"No match","")

Copy this down as far as necessary to cover your numbers.

Hope this helps.

Pete

On Apr 11, 9:23 pm, Theresa wrote:
I need to compare two columns of numbers and return what doesn't match. What
formula would I use?

compare two columns
 

You're welcome - thanks for feeding back.

Pete

On Apr 11, 10:55*pm, Theresa
wrote:
Thanks Pete, works great!



"Pete_UK" wrote:
If you want to see if any of the numbers in column A match with any of
the numbers in column B, then put this in C1:

=IF(ISNA(MATCH(A1,B:B,0)),"No match","")

Copy this down as far as necessary to cover your numbers.

Hope this helps.

Pete

On Apr 11, 9:23 pm, Theresa wrote:
I need to compare two columns of numbers and return what doesn't match.. *What
formula would I use?- Hide quoted text -

- Show quoted text -