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


    Edit: I updated your thread title.

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


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

    _______________________________________________

  • 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. :P


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


    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!