# Last Row in Excel

• Hi,

here is my problem.
Let's say I have 2 sheets in my workbook.
On sheet 1, I have a database with x number of columns.
in this database I will everyday add a line with information in every columns.
Ex : column A is the date
column B is a Brand of car (Ford, Renault, Toyota, etc...)
column C is the driver of the car

In sheet2, in a cell (whatever cell) : I am looking for a function that will take automatically the data of the last line of my sheet 1.
for ex in cell A1, I want the brand of the car (Column B) of the last line of sheet1.
Can someone help me ?

Thank you very much in advance

• Re: Function on excel

There is a few ways to do it... assuming there are no gaps in your rows, then this will do it -

In Sheet2, first cell where you want your data to appear...
=OFFSET(Sheet1!A1,COUNTA(Sheet1!\$A:\$A)-1,1,1,1)

And drag to the right for each column.

Ger

_______________________________________________
There are 10 types of people in the world. Those that understand Binary and those that dont.

Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

_______________________________________________

• Re: Last Row in Excel

=INDEX(Sheet1!B:B,COUNT(Sheet1!A:A))

Regards,

WidgetWonka
Puuuureeee Imagination

• Re: Last Row in Excel

Sorry, typo in my formula... should be...

=OFFSET(Sheet1!A1,COUNTA(Sheet1!\$A:\$A)-1,0,1,1)

_______________________________________________
There are 10 types of people in the world. Those that understand Binary and those that dont.

Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

_______________________________________________

• Re: Last Row in Excel

Or this one does not mind if you have missing/blank Row rows...
=INDEX(Sheet1!A:A,MAX(MATCH("*",Sheet1!A:A,-1)))

Ger

_______________________________________________
There are 10 types of people in the world. Those that understand Binary and those that dont.

Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

_______________________________________________

• Re: Last Row in Excel

Thank you GER PLANTER !
The function below works perfectly

=OFFSET(Sheet1!A1,COUNTA(Sheet1!\$A:\$A)-1,0,1,1)

The others don't work
Thx again

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!