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?