| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding NEXT to last, non zero numeric value in a row
trying to find a way to automatically return (via formula, not macro- I don't
know squat about macros), automatically return the NEXT TO LAST, non zero, numeric value in a row of cells. All info in the range is numeric. I found this one to find the LAST value: =LOOKUP(E1+100,1/(B3:CQ3),B3:CQ3) but i need the value to the immediate LEFT of what that formula returns. I am a complete newbie. Speak slowly and use small words. Don't know anything about macros, or any formulas beyond simple math |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding only cells with a numeric value | Excel Discussion (Misc queries) | |||
| Wildcard for finding the first numeric digit in a cell? | Excel Worksheet Functions | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Finding the mode (alpha numeric) | Excel Discussion (Misc queries) | |||
Threaded Mode
