| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Value of cell to determine range in MAX Function
Biff, not Bill.
(I'm here to help <vbg.) wrote: Thanks Bill, but I actually want the range to be from the cell directly above, to the row indicated by the value in the Q column. For example if Q21=5 and Q30=22, then K21 range needs to be from K20:K5 and K30 range needs to be from K29:K22. I can't seem to get this to work. Regards, Geoff. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to determine which cell the function =min() used? | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
Threaded Mode
