| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Next lower cell with number...
I have used the LOOKUP function before for such things but I am struggling
for a proper formula, using LOOKUP or otherwise, to grab the value of the next lower cell in a column without an #N/A value. So, #N/A #N/A 23.65 would return 23.65 Any ideas would be appreciated... my thanks in advance. Brad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if a number lower than 30 than the cell turns yellow?? | Excel Discussion (Misc queries) | |||
| automatically have cell change color when a number lower than n | Excel Discussion (Misc queries) | |||
| Highlight cell with lower number than one on another sheet | Excel Discussion (Misc queries) | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
| How can I find the row nr of the first number lower/ higher then a | Excel Discussion (Misc queries) | |||
Threaded Mode
