how to compare column?
Thanks Pete.
Is there anywhere to paste the entire column C ? not just one specific
cells, but 200 rows.
Thank you.
"Pete_UK" wrote in message
...
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.
|