how to compare column?
Put this in C1:
=IF(B1A1,"B","")
and copy down as required.
Hope this helps.
Pete
On Jan 18, 12:33*am, "Able Cox" wrote:
How do I compare colume
column A * *column B * *column C
22 * * * * * *33 * * * * * *B
22 * * * * * *14
12 * * * * * *3
27 * * * * * *45 * * * * * *B
55 * * * * * *40
How to compare column A with column B, then if B is greater than A, indicate
B in column C?
Thank you.
|