| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
"Aladin Akyurek" wrote...
You appear to be looking for the last non-zero value... =LOOKUP(2,1/(ABS(E1:INDEX(E1:E10,MATCH(9.99999999999999E+307, E1:E10)))0),E1:E10) .... I haven't tested, but LOOKUP doesn't mind if its 2nd and 3rd arguments are different size? Why would this be better than the simpler =LOOKUP(2,1/(-E1:E10<0),E1:E10) ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a linked cell | Links and Linking in Excel | |||
| finding the coordinates of the maximum point on a graph | Charts and Charting in Excel | |||
| finding data between two numbers (1000-1999)and totaling correspo. | Excel Discussion (Misc queries) | |||
| Finding Values in a "Matrix" | Excel Discussion (Misc queries) | |||
| Finding duplicate records in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
