Distinct values
exceljet.net
Distinct values
To extract a list of distinct values from a set of data (i.e. values that appear just once), you can use the UNIQUE function. In the example shown, the formula in D5 is: =UNIQUE(B5:B16,FALSE,TRUE) which outputs the 2 distinct values in the data, "purple", and "gray".
Oct 26, 2022
Excel Unique Function Tutorial
Excel UNIQUE function This function in Excel returns a list of unique values from a range or array. It works with any data type: text, numbers, dates, times, etc. #excel #exceltips #exceltutorial #reels | Excel Basics
0:40
Excel UNIQUE function This function in Excel returns a list of unique values from a range or array. It works with any data type: text, numbers, dates, times, etc. #excel #exceltips #exceltutorial #reels | Excel Basics
FacebookExcel Basics
1.1K viewsOct 30, 2023
Unique values with multiple criteria
Unique values with multiple criteria
exceljet.net
Oct 26, 2022
SUMIF & UNIQUE Function in Excel Comment your requests & questions for next tutorials! Follow for more!!! #SumIf #SumIfFunction #unique #UniqueFunction #CountIf #CountIfFunction#filterfunction #filter #excelformulas #excelfunctions #excelforbeginners #excelformula #exceltricks #excel_learning #exceltutoriales #excelpro #excelchallenge #excel #microsoftexcel #cursodeexcel #microsoft #office #msexcel #data #exceltips #aprenderexcel #microsoftoffice #powerbi #datascience #dataanalytics
1:14
SUMIF & UNIQUE Function in Excel Comment your requests & questions for next tutorials! Follow for more!!! #SumIf #SumIfFunction #unique #UniqueFunction #CountIf #CountIfFunction#filterfunction #filter #excelformulas #excelfunctions #excelforbeginners #excelformula #exceltricks #excel_learning #exceltutoriales #excelpro #excelchallenge #excel #microsoftexcel #cursodeexcel #microsoft #office #msexcel #data #exceltips #aprenderexcel #microsoftoffice #powerbi #datascience #dataanalytics
TikTokexcelwithnhel
228.1K viewsMay 21, 2023
Top videos
UNIQUE Function
UNIQUE Function
exceljet.net
Oct 26, 2022
How to Count distinct values in a range in Excel with Unique Function? shorts excel
0:29
How to Count distinct values in a range in Excel with Unique Function? shorts excel
humix.com
Oct 7, 2024
How to Find Count of Distinct & Unique Values in Microsoft #Excel 365 DISTINCT | Different Values, including Duplicates. =COUNTA(UNIQUE(Data[Names],,FALSE)) UNIQUE | Values that appear only once. =COUNTA(UNIQUE(Data[Names],,TRUE)) | Excel Basement
0:27
How to Find Count of Distinct & Unique Values in Microsoft #Excel 365 DISTINCT | Different Values, including Duplicates. =COUNTA(UNIQUE(Data[Names],,FALSE)) UNIQUE | Values that appear only once. =COUNTA(UNIQUE(Data[Names],,TRUE)) | Excel Basement
FacebookExcel Basement
12.1K views10 months ago
Excel Unique Function Examples
UNIQUE function in Excel (How to 6 Examples)
UNIQUE function in Excel (How to 6 Examples)
exceloffthegrid.com
Jan 24, 2023
Unique values ignore blanks
Unique values ignore blanks
exceljet.net
Aug 26, 2022
How to Count Unique Values in Excel with the UNIQUE Function
How to Count Unique Values in Excel with the UNIQUE Function
goskills.com
Feb 21, 2021
UNIQUE Function
UNIQUE Function
Oct 26, 2022
exceljet.net
How to Count distinct values in a range in Excel with Unique Function? shorts excel
0:29
How to Count distinct values in a range in Excel with Unique Functi…
Oct 7, 2024
humix.com
How to Find Count of Distinct & Unique Values in Microsoft #Excel 365 DISTINCT | Different Values, including Duplicates. =COUNTA(UNIQUE(Data[Names],,FALSE)) UNIQUE | Values that appear only once. =COUNTA(UNIQUE(Data[Names],,TRUE)) | Excel Basement
0:27
How to Find Count of Distinct & Unique Values in Microsoft #Exce…
12.1K views10 months ago
FacebookExcel Basement
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
Sep 9, 2020
excelcampus.com
Show Distinct Count in Excel Pivot Table
Show Distinct Count in Excel Pivot Table
Dec 15, 2020
pivot-table.com
nth largest without duplicates
nth largest without duplicates
Feb 24, 2023
exceljet.net
Unique values ignore blanks
Unique values ignore blanks
Aug 26, 2022
exceljet.net
Unique values with multiple criteria
Oct 26, 2022
exceljet.net
Count unique values with criteria
5 months ago
exceljet.net
How to find unique/duplicate values between two columns in excel?
May 17, 2012
extendoffice.com
Extract unique items from a list
May 16, 2024
exceljet.net
Count unique values in a range with COUNTIF
Aug 21, 2022
exceljet.net
How to count duplicates and unique values in Excel - TechRepublic
Jul 2, 2014
techrepublic.com
0:19
How to Use the UNIQUE() Function in Excel
4.3K views3 weeks ago
YouTubeTK Tech Tips
1:06
Excel UNIQUE Function Explained ✨📊 Tired of duplicates? The UNIQU…
363 views3 months ago
TikToknestordasecond
3:34
DISTINCT, VALUES - DAX Guide
21.2K viewsJun 24, 2021
YouTubeSQLBI
4:57
Count Distinct Values in Excel
15.2K viewsMay 10, 2020
YouTubeWareData
12:15
5 Excel Functions EVERYONE Needs
935.3K viewsJan 7, 2021
YouTubeLeila Gharani
8:14
How to Remove Duplicates in Excel
125.2K viewsJan 30, 2020
YouTubeKevin Stratvert
9:28
UNIQUE & FILTER Functions Dashboard Part 3 of 6
46.4K viewsJan 23, 2020
YouTubeExcel Campus - Jon
4:42
Distinct Count in Power BI DAX Tutorial (33/50)
24K viewsMar 31, 2021
YouTubeAnalytics with Nags
7:46
How To Use Count Distinct In An Excel Pivot Table Tutorial
942 viewsJan 31, 2020
YouTubeExcel Better
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex…
30.4K viewsApr 14, 2021
YouTubeChris Menard
4:39
A Formula For Non-adjacent Columns In Excel
35.3K viewsFeb 18, 2021
YouTubeExcel Campus - Jon
7:56
How to Extract Unique Values in Excel
47.8K viewsJun 10, 2021
YouTubeSimon Sez IT
0:55
How to Extract Unique Values from a Column in Excel
31.6K viewsJan 16, 2020
YouTubeFigureAssist
5:03
Find Unique Values in Microsoft Excel: 4 Methods for Beginners
37.5K viewsJun 4, 2021
YouTubeChris Menard
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tip…
107.2K viewsNov 8, 2019
YouTubedptutorials
7:42
How to Count Unique Rows with Power Query
50.8K viewsSep 17, 2020
YouTubeExcel Campus - Jon
See more videos
Static thumbnail place holder