| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stumped on Lookup Function
I would like to display the cell which holds the "last" positive number in a
column vector. (in other words...if the vector is a1:a3 with a1=2, a2=1, a3=0, then I would like to display the value in a2 (1).) It seems like the lookup function should work for this but I'm not sure how to specify "last positive number" in the function? Thanks in advance for any ideas. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Function help | Excel Discussion (Misc queries) | |||
| Lookup Function Problems | Excel Worksheet Functions | |||
| Stumped by a lookup scenario | Excel Worksheet Functions | |||
| lookup function 1 | Excel Worksheet Functions | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Threaded Mode
