Retrieve lowest (furthest down) value in a column in Excel
Posted on 2011-02-17
In Excel (2007), what is the simplest single formula or combination of formulas which will retreive the lowest (furthest down) value in a colum?
For example, suppose that many but not all of the cells in the range A1:A999 contain values. Moreover, suppose that you want a formula in cell A1000 which displays the value contained in the lowest cell in the column.
BTW, lowest cell here does not mean the one with the lowest or minimum value but means:
>the cell which is the greatest number of rows from the column headings
>the cell you'd be in if, from A1000, you press Ctrl+UpArrow
>all cells between it and A1000 are empty.
Sorry for the overblown definition of "lowest" but a bunch of definitions came to mind so take your pick! LOL
In fact, if you've got a better or goofier definition, it might add some levity to this otherwise very boring question -- so feel free!