Скачать или смотреть 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 Different...  

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 (2025)  

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