Get the Last Row of a PivotTable with INDEX/MATCH

preview_player
Показать описание

This video shows how to dynamically retrieve the last data row in a PivotTable. This technique continues to work when the data is updated and the PivotTable is refreshed.
Specifically:
- MATCH
- INDEX
- MATCH-1
- Combine functions
- Single formula
- Update data
- PivotTable refresh

Chapters in this video:
00:00 - Introduction
00:13 - Exercise 1
02:04 - click-start
02:08 - Exercise 2
03:54 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

  1. Excel University
  2. excel
  3. microsoft excel
  4. excel tips and tricks
  5. chatgpt
  6. chat gpt
Рекомендации по теме
How to get 0:15:41

How to get the Last Row in VBA(The Right Way!)

Excel How To 0:04:39

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

Excel VBA Basics 0:10:17

Excel VBA Basics #8 - Find the LAST ROW or COLUMN dynamically and clearing out your last report

Lookup the Last 0:04:40

Lookup the Last Value in a Column or Row in Excel | Get the Value in the Last Non-Empty Cell

How to get 0:00:16

How to get LAST ROW in SQL

Excel - Find 0:07:21

Excel - Find Last Non-Blank Cell Value, Row or Column

Finding the Last 0:15:44

Finding the Last Row or Column with an Excel VBA UserForm

Getting the Last 0:03:24

Getting the Last Row in Excel: The Most Common Mistake! Speed Tip

First win! 0:16:29

First win!

Get the Last 0:09:37

Get the Last Value in a Row - Excel Formula

How to Find 0:07:22

How to Find the Last Row of ALL Columns in UsedRange

Excel Tricks : 0:02:34

Excel Tricks : How To Go To Last Row/Column With Data | How To Select entire Row/Column |dptutorials

Google Sheets - 0:16:10

Google Sheets - Get Last Non-Empty Cell in Row or Column

Find Last Row 0:04:20

Find Last Row in Excel & Google Sheets data with a Formula

HOW TO Measure 0:02:13

HOW TO Measure and Install the LAST ROW of LAMINATE - Tricks

Excel VBA - 0:30:46

Excel VBA - Find Last Row in Data - Part 3

5 ways to 0:20:34

5 ways to go to the Last Row in Google Sheets

How to Get 0:05:10

How to Get Last Row and Column Using Google Apps Script

Find the Last 0:06:56

Find the Last Row, Column, or Cell in Excel VBA with the Range.End Method (Part 1 of 3)

Find the Last 0:13:49

Find the Last Row, Column, or Cell in Excel VBA with the Range.Find Method (Part 2 of 3)

Google Apps Script 0:03:10

Google Apps Script - Get the Last Row FOR A SINGLE COLUMN

How to Get 0:24:34

How to Get The Last Row - Google Sheets Apps Scripts - Array Methods Part 10

Excel Office Script 0:11:47

Excel Office Script - Find Last Row, Last Column (JavaScript, TypeScript)

VBA Find Last 0:16:42

VBA Find Last Row on a Sheet, in a Range, or Table - Weekend Event

Комментарии
Автор

I like index and match combined, very useful. thanks for the reference video for future, Paul

PaulEBrownbill
Автор

Why use columns, which may have data included, to establish the last cell of a pivot table, if using the table's own range, the answer is more reliable?
=INDEX(C6:C10, ROWS(C6:C10)-1) - for the data
=INDEX(C6:C10, ROWS(C6:C10)) - for the grand total 🤗

JoseAntonioMorato