Excel How To Get the Last Row and Last Column Value with TAKE
File Download: https://www.excel-university.com/yt_t...
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
Watch the previous video Excel How To Combine Tables with Different Column Orders • Excel How To Combine Tables with Diff...
Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/yt
Check out Excel PivotTables for Beginners (2023) • Excel PivotTables for Beginners (2024)
Subscribe here 👉 / @excelu
and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here • Vlookup Hacks: Hack #1 Sort Order
