How can I reference the last data item in a column or row?

  • Thread starter Thread starter snappy
  • Start date Start date
S

snappy

I want to display or use the last (most recent) data in either a column

or row withour specifically accessing the individual cell. Is there a
funcion similar to Min() or Max() that can help me or perhaps another
way to solve this question?


Thanks
 
Hi!

Try this:

Note: this will not work on an entire column, i.e. A:A, but will work on an
entire row, i.e. 1:1

=LOOKUP(2,1/(A1:A20<>""),A1:A20)

Biff
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Retrieving data from a cell in the last row containing data in the worksheet 1
Find the last, 2nd last and 3rd last data in a column 3
formula to display the max (or min value) for an entire column, basedon value in an individual cell 1
Last entry in a column 6
Extracting data from Multiple columns to a Single row 1
Paste in column B using Last row of either column B, C or D. 10
Filter out rows based on the value of a cell 4

Back
Top