Last Entry in Column

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I am simply trying to devise a formula that will allow me
to get the last entry made in a column to show up in a
different cell.
 
... or if you don't know if its numeric or text, try
=INDIRECT("B"&MAX(IF(NOT(ISBLANK(B1:B100)),ROW(1:100)

which is an array formula, so enter with CTRL-SHIFT-ENTER
 
Back
Top