ExcelBanter - matching numbers in col a and col b

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - matching numbers in col a and col b (https://www.excelbanter.com/excel-worksheet-functions/45384-matching-numbers-col-col-b.html)

Jim

matching numbers in col a and col b

I have two columns a nd b. I have numbers in both columns. I need a formula
to compare both columns and idenify the amounts that are not the same in both
columns.

Bob Phillips

=IF(A1<B1,"Not the same","")

and copy down.

--
HTH

Bob Phillips

"Jim" wrote in message
...
I have two columns a nd b. I have numbers in both columns. I need a
formula
to compare both columns and idenify the amounts that are not the same in
both
columns.

All times are GMT +1. The time now is 03:50 PM.