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
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
5 Excel Functions EVERYONE Needs
12:15
5 Excel Functions EVERYONE Needs
YouTubeLeila Gharani
935.3K viewsJan 7, 2021
How to use the TEXTJOIN function in Excel
2:51
How to use the TEXTJOIN function in Excel
YouTubeTechOnTheNet
89.4K viewsMay 13, 2021
Top videos
How to distinct value in a list in excel #Excel #exceltraining #exceltutorial #exceltricks #exceltips #GoogleSheets LEARN MORE | LEARN MORE
0:29
How to distinct value in a list in excel #Excel #exceltraining #exceltutorial #exceltricks #exceltips #GoogleSheets LEARN MORE | LEARN MORE
FacebookLEARN MORE
674 viewsMay 31, 2023
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
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
excelcampus.com
Sep 9, 2020
Excel Dynamic Arrays
New Excel Features: Dynamic Array Formulas & Spill Ranges - Excel Campus
9:06
New Excel Features: Dynamic Array Formulas & Spill Ranges - Excel Campus
excelcampus.com
Jan 1, 2009
Working With Excel Dynamic Arrays | GoSkills
Working With Excel Dynamic Arrays | GoSkills
goskills.com
Feb 2, 2022
How to Use Spills and Arrays in Excel 365
6:20
How to Use Spills and Arrays in Excel 365
YouTubeSimon Sez IT
5K viewsDec 23, 2024
How to distinct value in a list in excel #Excel #exceltraining #exceltutorial #exceltricks #exceltips #GoogleSheets LEARN MORE | LEARN MORE
0:29
How to distinct value in a list in excel #Excel #exceltraining #exceltutorial #exceltricks #exceltips #GoogleSheets LEARN MORE | LEARN MORE
674 viewsMay 31, 2023
FacebookLEARN MORE
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
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
UNIQUE Function
UNIQUE Function
Oct 26, 2022
exceljet.net
Unique values ignore blanks
Unique values ignore blanks
Aug 26, 2022
exceljet.net
Unique values from multiple ranges
Unique values from multiple ranges
Aug 13, 2024
exceljet.net
Unique values with multiple criteria
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
Show Distinct Count in Excel Pivot Table
Dec 15, 2020
pivot-table.com
How to count duplicates and unique values in Excel - TechRepublic
Jul 2, 2014
techrepublic.com
1:06
Excel UNIQUE Function Explained ✨📊 Tired of duplicates? The UNIQUE function pulls out distinct values instantly! 🚀 Perfect for clean lists, drop-downs, and dashboards. Try it in Excel 365 or 2021! 💻
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
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 Excel
30.4K viewsApr 14, 2021
YouTubeChris Menard
5:10
How To Find Unique Values Using Advanced Filter In Excel
387.9K viewsNov 9, 2017
YouTubeExcel Campus - Jon
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
9:07
How to COUNT in Power BI // COUNT, COUNTA, DISTINCTCOUNT, COUNTBLANK, COUNTROWS, COUNTX, COUNTAX
129.1K viewsNov 4, 2020
YouTubeFernan | Power BI
3:00
Excel Tip: How To Use Distinct or Unique Count In An Excel Pivot Table
737 viewsJun 28, 2016
YouTubeHow To Excel At Excel.Com
14:02
QTT - Power Apps Distinct Dropdown - Filter, SortByColumns, Delegation, AddColumns, UnGroup and more
60.8K viewsDec 10, 2020
YouTubeShane Young
7:43
Dealing with Duplicates in Excel and Finding Unique Data
161.8K viewsNov 5, 2018
YouTubeTechnology for Teachers and Students
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tips & Tricks || dptutorials
107.2K viewsNov 8, 2019
YouTubedptutorials
12:19
Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence
118.1K viewsAug 27, 2020
YouTubeInnozant
See more