how to compare column?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Able Cox - 18 Jan 2008 00:33 GMT

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.

Reply to this Message

Pete_UK - 18 Jan 2008 00:51 GMT

Put this in C1:

=IF(B1>A1,"B","")

and copy down as required.

Hope this helps.

Pete

> How do I compare colume
>
[quoted text clipped - 9 lines]
>
> Thank you.

Reply to this Message

Able Cox - 18 Jan 2008 04:16 GMT

Thanks Pete.

Is there anywhere to paste the entire column C ? not just one specific
cells, but 200 rows.

Thank you.

Put this in C1:

=IF(B1>A1,"B","")

and copy down as required.

Hope this helps.

Pete

On Jan 18, 12:33 am, "Able Cox" <no.s...@no.spam.com> wrote:

> How do I compare colume
>
[quoted text clipped - 10 lines]
>
> Thank you.

Reply to this Message

David Biddulph - 18 Jan 2008 12:12 GMT

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

Signature

David Biddulph

> Thanks Pete.
>
[quoted text clipped - 28 lines]
>>
>> Thank you.

Reply to this Message

Able Cox - 18 Jan 2008 19:53 GMT

Thank you.

>A number of ways of copying:
>
[quoted text clipped - 37 lines]
>>>
>>> Thank you.

Reply to this Message