Last Number in a column

  • Thread starter Thread starter DME
  • Start date Start date
D

DME

Is there a formula to display the last number in a column.

I have data rows 1-31 in 12 different columns. I want a to be able to pick
up a the last number entered in each of the columns. So for instance and
have data in rows 1-23 in column A, the data in rows 1-31 ni col B. Is
there a formula to put in row 45 that will pick up the last # entered in a
column.

Thanks for the help.
 
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
Help needed 0
Excel Help to copy information from one row at a time to another sheet 1
Column number of last column that returns value ignore formulas 8
Excel 2002: How to get the first and last reference in a column ? 7
Excel Subtracting multiple columns from another column 3
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
counting blank cells within two columns 2

Back
Top