Excel Count Array From Unique Function - Search Videos

Count unique values

Count unique values

To count unique values in a set of data, you can use the UNIQUE function together with the COUNTA function. In the example shown, the formula in F5 is: =COUNTA(UNIQUE(B5:B16)) which returns 7, since there are seven unique colors in B5:B16.

Excel Pivot Table

Pivot Table Excel | Step-by-Step Tutorial

Pivot Table Excel | Step-by-Step Tutorial

YouTubeKevin Stratvert

1.4M viewsOct 7, 2024

Create a PivotTable in Microsoft Excel

Create a PivotTable in Microsoft Excel

YouTubeMicrosoft 365

270.6K viewsFeb 12, 2021

How to Make Pivot Chart in Excel

How to Make Pivot Chart in Excel

YouTubeKevin Stratvert

352.3K viewsOct 13, 2023

Top videos

UNIQUE Function

UNIQUE Function

How to Count Unique Values in Excel with the UNIQUE Function

How to Count Unique Values in Excel with the UNIQUE Function

Count unique values with criteria

Count unique values with criteria

Excel Formulas and Functions Tutorial

Excel Formulas and Functions Tutorial

YouTubeKevin Stratvert

4.2M viewsJul 13, 2019

Excel Formulas and Functions You NEED to KNOW!

Excel Formulas and Functions You NEED to KNOW!

YouTubeLeila Gharani

951.9K viewsFeb 11, 2021

Microsoft Excel Tutorial for Beginners #3 - Calculations (Formulas)

Microsoft Excel Tutorial for Beginners #3 - Calculations (Formulas)

YouTubeMotionTraining

1.8M viewsApr 24, 2008

UNIQUE Function

UNIQUE Function

How to Count Unique Values in Excel with the UNIQUE Function

How to Count Unique Values in Excel with the UNIQUE Function

Count unique values with criteria

Count unique values with criteria

Count unique numeric values with criteria

Count unique numeric values with criteria

Count unique values in a range with COUNTIF

Count unique values in a range with COUNTIF

Count unique text values with criteria

Count unique text values with criteria

Count unique text values in a range

Count unique text values in a range

Count unique numeric values in a range

Count items in list

Distinct Count Report with Dynamic Array Formulas - Excel Campus

excelcampus.com

How to count duplicates and unique values in Excel - TechRepublic

techrepublic.com

COUNTIF with non-contiguous range

Unique values with multiple criteria

Unique values from multiple ranges

Running count of occurrence in list

Extract unique items from a list

Use Excel’s UNIQUE function to filter unique items, and COUNTIF t…

22.3K viewsMar 2, 2023

TikTokexcelbykarstrom

How to Get a Distinct Count of Unique Values in Excel (Full Guid…

YouTubeAI Mastery

How to Use Arrays to SUM Data in Excel

14K viewsOct 22, 2019

YouTubeMyExcelOnline.com

How to use COUNTIF and COUNTIFS in Microsoft Excel

1M viewsJan 27, 2020

YouTubeKevin Stratvert

How to Use the FREQUENCY Function in Excel - Array Formula …

55.6K viewsOct 4, 2019

YouTubeExcel Bootcamp

How to count unique values Excel

245.6K viewsJul 24, 2018

YouTubeSpreadsheetWeb

How to Count Unique Text Values in a Range in Excel

20.1K viewsJun 4, 2019

YouTubeExcelchat

Excel: Combine the awesome UNIQUE and SORT functions in Ex…

30.5K viewsApr 14, 2021

YouTubeChris Menard

How To Find Unique Values Using Advanced Filter In Excel

388.1K viewsNov 9, 2017

YouTubeExcel Campus - Jon

A Formula For Non-adjacent Columns In Excel

35.3K viewsFeb 18, 2021

YouTubeExcel Campus - Jon

Two Excel Dynamic Array Functions: UNIQUE and SORT

53.1K viewsMay 10, 2021

YouTubeTechnology for Teachers and Students

Find Unique Values in Microsoft Excel: 4 Methods for Beginners

37.6K viewsJun 4, 2021

YouTubeChris Menard

Unique Rank in Excel - Combining Rank and CountIF

32.8K viewsMay 8, 2017

YouTubePaula's Web3 & Crypto

See more videos