All
Search
Images
Videos
Shorts
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Top suggestions for How to Distinct a Column in Excel
How to Separate
a Column in Excel
How to Count
a Column in Excel
How to Sum
a Column in Excel
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
How to Separate
a Column in Excel
How to Count
a Column in Excel
How to Sum
a Column in Excel
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 Formulas
1:27
Overview of formulas in Excel
Microsoft
May 20, 2014
Learn Basic Formulas for Excel
corporatefinanceinstitute.com
Mar 6, 2025
Excel formulas and functions
exceljet.net
Oct 26, 2022
Top videos
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
excelcampus.com
Sep 9, 2020
0:34
How to Divide Two Columns in Excel: Easy Step-by-Step Tutorial
wikiHow
56.4K views
3 months ago
Count unique values with criteria
exceljet.net
6 months ago
Excel Pivot Tables
20:49
How to Create Pivot Table in Excel
YouTube
Kevin Stratvert
2.5M views
Oct 10, 2022
8:36
Pivot Table Excel | Step-by-Step Tutorial
YouTube
Kevin Stratvert
1.4M views
Oct 7, 2024
12:46
How to Easily Build Excel Pivot Tables from Scratch!
YouTube
Technology for Teachers and
77.9K views
11 months ago
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
Sep 9, 2020
excelcampus.com
0:34
How to Divide Two Columns in Excel: Easy Step-by-Step Tutorial
56.4K views
3 months ago
wikiHow
Count unique values with criteria
6 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
How to count duplicates and unique values in Excel - TechRepublic
Jul 2, 2014
techrepublic.com
3:34
DISTINCT, VALUES - DAX Guide
21.4K views
Jun 24, 2021
YouTube
SQLBI
4:57
Count Distinct Values in Excel
15.2K views
May 10, 2020
YouTube
WareData
8:14
How to Remove Duplicates in Excel
124.8K views
Jan 30, 2020
YouTube
Kevin Stratvert
3:56
Power BI DISTINCT table or column function
8.6K views
Aug 3, 2020
YouTube
Life of Business Analyst
1:00
Split data into different columns in Microsoft Excel
2.4M views
Oct 9, 2019
YouTube
Microsoft 365
0:26
How to count unique values Excel
245.6K views
Jul 24, 2018
YouTube
SpreadsheetWeb
5:24
Count duplicate values in excel | Using Formulas
221.9K views
Jan 8, 2021
YouTube
ExcelTips
2:35
How To Split Excel Cells Into Columns
56.9K views
Mar 23, 2021
YouTube
Insider Tech
7:46
How To Use Count Distinct In An Excel Pivot Table Tutorial
942 views
Jan 31, 2020
YouTube
Excel Better
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex
…
30.5K views
Apr 14, 2021
YouTube
Chris Menard
4:39
A Formula For Non-adjacent Columns In Excel
35.3K views
Feb 18, 2021
YouTube
Excel Campus - Jon
3:31
Distinct Count in Multiple Columns in Power BI
5.1K views
Aug 19, 2020
YouTube
Ritesh Sharma
7:56
How to Extract Unique Values in Excel
48.2K views
Jun 10, 2021
YouTube
Simon Sez IT
7:03
Pivot Table Excel Tutorial - Difference between two columns
76K views
Oct 31, 2019
YouTube
MyExcelOnline.com
0:55
How to Extract Unique Values from a Column in Excel
31.6K views
Jan 16, 2020
YouTube
FigureAssist
9:31
How to Split Data into Columns using Delimiter in Excel
45.2K views
Aug 29, 2019
YouTube
S K Shares Tech
5:03
Find Unique Values in Microsoft Excel: 4 Methods for Beginners
37.5K views
Jun 4, 2021
YouTube
Chris Menard
3:29
How To Format Subheadings and Columns and lists in excel
142.6K views
Aug 19, 2019
YouTube
SpreadsheetLessons
3:23
SQL DISTINCT Statement | How to get unique values from a column i
…
15.3K views
Oct 8, 2020
YouTube
The Data Millennials
1:46
SQL SELECT DISTINCT statement (return different values) | SQL Tut
…
21.3K views
Jun 14, 2021
YouTube
Amit Thinks
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tip
…
107.2K views
Nov 8, 2019
YouTube
dptutorials
7:42
How to Count Unique Rows with Power Query
50.5K views
Sep 17, 2020
YouTube
Excel Campus - Jon
1:29
How to Select Two Different Columns in Excel at the Same Time
162.1K views
Aug 9, 2021
YouTube
Excel Tutorials by EasyClick Academy
See more videos
More like this
Feedback