| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
