How about:

=MAX($B$4,C1)
copied down

HTH
Jean-Guy

"Trevor Shuttleworth" wrote:

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