| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
retrieve the last value in a column - JulieD
to retrieve the last value in a column
=LOOKUP(2,1/(-E1:E10<0),E1:E10) Where A1:A10 is the range you're interested in. Cheers JulieD Could someone explain the mechanics of the first two arguments in this formula? I realize that Julie's comment referenced the wrong range in the formula, but what is Excel doing when it reads this? Mike F |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find duplicate cells in Column a & retrieve column B | Excel Discussion (Misc queries) | |||
| retrieve column index... | Excel Discussion (Misc queries) | |||
| PING: JulieD & AlfD re Sorting By Postcode | Excel Discussion (Misc queries) | |||
| JulieD | Excel Discussion (Misc queries) | |||
| How to Retrieve Last Used Cell In Column | Excel Programming | |||
Threaded Mode
