Excel How To Get the Last Row and Last Column Value with TAKE

This Excel video shows how to retrieve values from the last row of a table as well as the last column of a table. We'll use the TAKE and XLOOKUP functions to accomplish this.

Chapters:
00:00 - Introduction
00:24 - TAKE
02:38 - XLOOKUP

and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!

[matthewwerstler]

Thanks Excel University - I was having trouble remember how this worked, and I am very grateful how simple you made this explanation.
The naming helped me search it up online, but you could add TAKE to the end for even more SEO traffic.

[PaulEBrownbill]

Thanks, good video to show how to use two functions. Paul

[ricigri]

The only video that saved my life. Huge thank you

[LamaHI]

Thank you sooo much. This saved me a lot of time.

[ornashuva]

Thanks for the great explanation. I would have one question: if the table is not in a defined range (ie each month I add further rows to a table) how can I still get the last 'entry/value' of that column? For me it's a date, however by using =TAKE(C6:C110, -1, -1) the system returns 00/01/1900 on empty cells (formated as date). thanks alot

[Anonymous-znqo]

Is there any alternative functions which we can use in older excel version's and get the same result

[behfar]

how can this be used for when you are adding new columns, as opposed to new rows?

[shahidhabib-umev]

Dear SIR I WANT TO ASK A QUESTION CAN I ASK ?

[parksooby]

why does my excel doesn't have take function? i'm so confuse

[jacqal]

Hey - what if we just wanted a cell in the row?

[johnx]

Can we use this function in excel 2007?