software

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

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

Trevorquot;Building Model Sailboats is great funquot; lt;Building Model Sailboats is great
gt; wrote in message
...
gt; Seek help in Excel,
gt; How can a list of numbers be generated in Column D representing the
gt; greater
gt; of either a fixed number, say quot;B4quot; and a varying list of numbers in
gt; column C?
gt; Thank you
gt; Jim Moore
How about:

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

HTH
Jean-Guy

quot;Trevor Shuttleworthquot; wrote:

gt; Jim
gt;
gt; I'm not quite sure what you're trying to do but maybe this will help:
gt;
gt; =MAX($B$4,C:C)
gt;
gt; or do you mean something like:
gt;
gt; in cell D1: =MAX($B$4,C1) (and drag down)
gt; in cell D2: =MAX($B$4,C2) (and so on)
gt;
gt; Regards
gt;
gt; Trevor
gt;
gt;
gt; quot;Building Model Sailboats is great funquot; lt;Building Model Sailboats is great
gt; gt; wrote in message
gt; ...
gt; gt; Seek help in Excel,
gt; gt; How can a list of numbers be generated in Column D representing the
gt; gt; greater
gt; gt; of either a fixed number, say quot;B4quot; and a varying list of numbers in
gt; gt; column C?
gt; gt; Thank you
gt; gt; Jim Moore
gt;
gt;
gt;

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.

quot;Trevor Shuttleworthquot; wrote:

gt; Jim
gt;
gt; I'm not quite sure what you're trying to do but maybe this will help:
gt;
gt; =MAX($B$4,C:C)
gt;
gt; or do you mean something like:
gt;
gt; in cell D1: =MAX($B$4,C1) (and drag down)
gt; in cell D2: =MAX($B$4,C2) (and so on)
gt;
gt; Regards
gt;
gt; Trevor
gt;
gt;
gt; quot;Building Model Sailboats is great funquot; lt;Building Model Sailboats is great
gt; gt; wrote in message
gt; ...
gt; gt; Seek help in Excel,
gt; gt; How can a list of numbers be generated in Column D representing the
gt; gt; greater
gt; gt; of either a fixed number, say quot;B4quot; and a varying list of numbers in
gt; gt; column C?
gt; gt; Thank you
gt; gt; Jim Moore
gt;
gt;
gt;