View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.