How do i make a formula reference the last entry of a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I am entering data on a sheet each day and analyzing it on a separate
sheet. Many of the formulas i use need to reference the newest entries. Can
anyone tell me the function you use so that the formula automatically uses
the last entry in a column (so that all i need to do is key in the data each
day.
 
Look at the OFFSET function. The row offset would be a COUNT or COUNTA of
the entire column for which you wish to find the last entry. This of course
requires that there are no blank rows in the data.

PC
 
Try this:

=LOOKUP(2,1/(1-ISBLANK(A1:A1000)),A1:A1000)

Will work with blank cells within the column, but don't use entire column
references (A:A).
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
You must log in or register to reply here.

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

formula for displaying only the last entry of a group of cells 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Excel Dragging countif formula with changing criteria 3
What formula do I use to show the last cell with text in a colum 3
Formula to display last entry in a column populated with #N/As 4
using the =page! feature to transpose a row to column 0
Formula to choose from the last column of a given row 1
changing multiple column references in a formula 5

Back
Top