Excel Magic: Use SUBTOTAL with Filters for Dynamic Totals (Sort & Unique Data Too!)
2:37
Excel Magic: Use SUBTOTAL with Filters for Dynamic Totals (Sort & Unique Data Too!)
18 views8 months ago
YouTubeThe Engineering Program
How to Find Count of Distinct & Unique Values in Microsoft #Excel 365 (When the Data is Filtered) ? Distinct: =COUNTA(UNIQUE( FILTER(Data[Names], SUBTOTAL(103, OFFSET(B16,ROW(Data[Names]) -ROW(B16),0))),,FALSE)) Unique: =COUNTA(UNIQUE( FILTER(Data[Names], SUBTOTAL(103, OFFSET(B16,ROW(Data[Names]) -ROW(B16),0))),,TRUE)) | Excel Basement
0:44
How to Find Count of Distinct & Unique Values in Microsoft #Excel 365 (When the Data is Filtered) ? Distinct: =COUNTA(UNIQUE( FILTER(Data[Names], SUBTOTAL(103, OFFSET(B16,ROW(Data[Names]) -ROW(B16),0))),,FALSE)) Unique: =COUNTA(UNIQUE( FILTER(Data[Names], SUBTOTAL(103, OFFSET(B16,ROW(Data[Names]) -ROW(B16),0))),,TRUE)) | Excel Basement
2.9K views11 months ago
FacebookExcel Basement
Using the Excel SUBTOTAL Function
4:57
Using the Excel SUBTOTAL Function
316.8K viewsJul 3, 2023
YouTubeTechnology for Teachers and Students
How To Use The Subtotal Feature And Subtotal Function In Excel
8:08
How To Use The Subtotal Feature And Subtotal Function In Excel
378.9K viewsJul 2, 2020
YouTubeExcel Campus - Jon
Excel - How to use the Subtotal Function with Filters
4:38
Excel - How to use the Subtotal Function with Filters
47.4K viewsOct 22, 2021
YouTubeChris Menard
Master Advanced Excel Features | Sorting, Filtering, Subtotal & Data Validation
1:04:45
Master Advanced Excel Features | Sorting, Filtering, Subtotal & Data Validation
245 views1 month ago
YouTubeIT TECH
Excel - Count Unique Values
2:47
Excel - Count Unique Values
3.5K views4 months ago
YouTubeChester Tugwell
1:14
Master SUBTOTAL in Excel | Complete Guide #excel #exceltutorial
356 viewsJun 18, 2025
YouTubeUpgradedZero
0:17
Excel Trick Pros Use: SUBTOTAL Average That Changes with Filters
400 views5 months ago
YouTubeWishInfinite
2:05
Excel's SUBTOTAL: The One Number Difference That Changes Everything
1.2K viewsMay 19, 2025
YouTubeUp4Excel
7:00
SUBTOTAL in Excel | Full Beginner to Pro Guide
457 views6 months ago
YouTubeS2 Computer Education
11:01
SUBTOTAL: The Excel Function You Didn’t Know You Needed!
27.3K viewsMar 23, 2025
YouTubeKenji Explains
0:22
Count Unique Values in Excel Like a Pro 💯 | Easy Formula for Beginners 🔥 #focusinguide #exceltips
34.7K views8 months ago
YouTubeFocus in Guide
0:14
Excel Tutorial: Count unique values in seconds 🤯Find unique + count instantly 📊
1.4K views2 months ago
YouTubeMr.Wonderful-AS
0:26
How to count unique values Excel
246.5K viewsJul 24, 2018
YouTubeSpreadsheetWeb
1:09
How to count unique values with criteria in Excel - Count unique items based on condition
88.9K viewsApr 15, 2024
YouTubeExcel Bootcamp
3:59
How to Count Unique Entries in Excel 365
44.3K viewsOct 7, 2024
YouTubeSimon Sez IT
6:16
How to use SUBTOTAL Formula in Microsoft Excel | SUBTOTAL Function in Excel
27.7K viewsApr 29, 2025
YouTubeStudySpan
1:07
SUBTOTAL Formula in Excel | Calculate Total, Average & Count with Filters #excel #aggregatefunctions
662 views6 months ago
YouTubeCode With DK Sir
2:49
Excel Unique Count of Visible Rows - Episode 2399
25.3K viewsApr 11, 2021
YouTubeMrExcel.com
5:45
How to Create Subtotal in Microsoft Excel Part-II
289.8K viewsJul 29, 2020
YouTubeStudySpan
1:02
Excel Subtotals Made EASY Automatically
2K views4 months ago
YouTubedptutorials
0:15
Subtotal(109) = Smart Sum
264 views4 months ago
YouTubeExcel Tutorials Hub By Prabhakar
0:54
The BIG MISTAKE You're Making with Unique Values in Excel - Fix It Now
726 views4 months ago
YouTubedptutorials
5:11
How to get a distinct count of unique values in Excel
19.6K viewsSep 22, 2022
YouTubeNate Chamberlain
0:22
Master the SUBTOTAL Function in Excel in Minutes!
3.5K views1 year ago
YouTubeTech Gitter Official
4:24
Excel: Groups and Subtotals
1.7K views9 months ago
YouTubeLearnFree
0:32
Learn subtotal with count function in excel#skctrlcraft
58 views6 months ago
YouTubesk Ctrlcraft
7:07
The SUBTOTAL Formula: A Hidden Excel Treasure
68 viewsFeb 16, 2025
YouTubeLearn With Javed 💻
2:58
Sum Filtered Data in Excel with SUBTOTAL (The Right Way!)
416 views11 months ago
YouTubeEasy Click Learning
See more
Static thumbnail place holder