View Single Post
  #1   Report Post  
ANJ
 
Posts: n/a
Default Function to list values of last 3 non-blank cells in a vertical bl

Excel 2003. Looking for a function to examine a specified vertical block of
cells (ie- B1:B25) and output the values of the last three cells that are not
blank. For example, if cells B1:B7 contain text, this function should return
the values of B7, B6 and B5. If I add text to cell B8, the function should
then return the values of B8, B7 and B6.

Any hints or knowledge of functions that do similar things would be
appreciated.

TIA