Last Entry in Column

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.
 
B

Bob Phillips

... 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Recover Outlook calendar entry 1
calculate last 4 data points in a column (with sometimes blank rows) 7
Excel does not accept text format! 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
formula for displaying only the last entry of a group of cells 2
An old chestnut: finding the last cell in a range 10
Hide columns based on row values 2

Top