How: List in col D whichever number greater; B4 or varying # in Co

  • Thread starter Building Model Sailboats is great fun
  • Start date
B

Building Model Sailboats is great fun

Seek help in Excel,
How can a list of numbers be generated in Column D representing the greater
of either a fixed number, say "B4" and a varying list of numbers in column C?
Thank you
Jim Moore
 
T

Trevor Shuttleworth

Jim

I'm not quite sure what you're trying to do but maybe this will help:

=MAX($B$4,C:C)

or do you mean something like:

in cell D1: =MAX($B$4,C1) (and drag down)
in cell D2: =MAX($B$4,C2) (and so on)

Regards

Trevor


"Building Model Sailboats is great fun" <Building Model Sailboats is great
[email protected]> wrote in message
news:[email protected]...
 
B

Building Model Sailboats is great fun

Trevor,
Thank you. This is first time I've entered this help group. It's great.
I will now enter(=MAX($B$4,C1) in column D.
Then I'll copy the above and paste in all of column D.
This will give me what i wanted.
 
Top