| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How: List in col D whichever number greater; B4 or varying # in Co
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in col D whichever number greater; B4 or varying # in Co
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in col D whichever number greater; B4 or varying # in Co
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in col D whichever number greater; B4 or varying # in Co
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. "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find first occurence in a list that's greater than a specific num | Excel Worksheet Functions | |||
| display actual number or zero, whichever is greater | Excel Discussion (Misc queries) | |||
| count a number that is less than a number and greater than a numbe | Excel Worksheet Functions | |||
| I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
Linear Mode
