how to compare column?
 

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.

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.

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.

how to compare column?
 

A number of ways of copying:

Copy C1, select C2:C20, and Paste.
or
Select the fill handle in the bottom right hand corner of C1 (to get a black
square there), and drag it down C2:C200
or
Double-click on the fill handle of C1 (see above), and it should fill down
as far as you have data in column B
--
David Biddulph

"Able Cox" wrote in message
...
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.

how to compare column?
 

Thank you.

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
A number of ways of copying:

Copy C1, select C2:C20, and Paste.
or
Select the fill handle in the bottom right hand corner of C1 (to get a
black square there), and drag it down C2:C200
or
Double-click on the fill handle of C1 (see above), and it should fill down
as far as you have data in column B
--
David Biddulph

"Able Cox" wrote in message
...
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.