Understanding THE POWER OF Unique Function (with Examples) COMPOUNDING
Understanding Unique Function in Excel • The Unique function helps remove duplicate values from a list and keep only the unique/ distinct values. • This function is very useful for creating a dynamic unique list of values from a data set. • This function is available only in Microsoft Excel 365. It is not available in earlier versions of excel. Email: Support@skillfinlearning.com
Mobile: 9650010925
Unique Function arguments =Unique(array,[by_col],[exactly_once])
•Array : - It is the range or array from which to return the unique value from rows or columns
Email: Support@skillfinlearning.com
•By Column :- In most cases, the values are pulled from the rows.
•Exactly once :- This argument helps pick values which appear only once in a list.
•The default value for this argument is “False”.
•The default value for this argument is “False”.
•To select the unique values from a column list, we should enter “True” in the argument.
•To select only the unique values which appear only once in the list, we should enter “True” for this argument.
Mobile: 9650010925
Example 1: Understanding Unique Function (1/2) Here is a list of customers of ABC Limited who visited the store in the month of Jan
• To get the list of unique first name, Type =Unique(B5:B14) • Press Enter • We get the below list
• The names of customer Alex, James and John is appearing more than once in the original list. • When we used the unique function, we get the list with all the names appearing just once in the list. Email: Support@skillfinlearning.com
Mobile: 9650010925
Example 1: Understanding Unique Function (2/2) Here is a list of customers of ABC Limited who visited the store in the month of Jan
• In case, we want the list of customers whose name appears just once in the original list • We will use the first and third argument in the unique function.` • Type =Unique(B5:B14,,True) • Press Enter`
• We get the list of names appearing only once in the list.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Example 2: Creating Unique List of First & Last names of Customers We have the same list of customers with First and Last Names as in the previous example.
• If we want to get the unique First and Last names in the list, Type = Unique(B5:C14) • Press Enter • We get the unique list of First and last names.
• James Anderson appearing twice in the original list is appearing once in this list
Email: Support@skillfinlearning.com
Mobile: 9650010925
Example 3: Creating Unique List of First & Last names in a single cell • We can also combine the first and last names of customers while using the unique function with slight modifications.
We have the same list of customers with First and Last Names as in the previous example.
• To get this combined list, type =unique(B5:B14&” “&C5:C14) • Press Enter. • We get the below list.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Example 4: Creating Unique List by columns (1/2) • • • •
In most cases, the Unique function is applied to a list of items in a data set, provided in the rows. The unique function, therefore, gets the unique data points from rows by default. In case we want a unique list from columns then we should use the second argument in the unique function. In this example, we have the list of customers in rows and dates in a column.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Example 4: Creating Unique List by columns (2/2) • To get a unique list of dates from the columns. We will use the first two arguments of the function.
• To get this list in a single column, use the Transpose function along with the unique function.
• Leave the third argument, Exactly once as blank. • Type = Transpose(Unique(C4:H4,True))
• To get the list, we type =unique(C4:H4,True)
• Press Enter • Press Enter • We get the list in a single column. • We get the following list of unique dates.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Want to learn more? Explore our “Data Analysts Skills Training” (DAST) course Go from beginner to an Expert in Data analytics Skills in Excel. Join this program to build your Excel analytical skill quickly through hands on project Skills you will master: ✓ Data analytics functionalities in Excel ✓ Data visualization through charts ✓ Logical analysis driven decision-making ✓ Data cleaning and improvisation methods ✓ Pivot Table analysis ✓ Professionally format datasheets ✓ Excel tips and tricks using shortcuts ✓ Excel skills for business purposes ✓ Apply data analysis on real life datasets
Coaching includes: ✓ Annual (1 year) Subscription ✓ 100+ Live Interactive Sessions ✓ Unlimited Access to Video Content ✓ Weekly Mentorship Assistance ✓ Individual Assignments Evaluation ✓ Access on Mobile and Tablet also ✓ Certificate of Completion For more details please visit Data Analyst Skills Training (DAST)
Email: Support@skillfinlearning.com
Mobile: 9650010925
Our Training approach ensures You Learn Effectively in Less Time
Email: Support@skillfinlearning.com
Mobile: 9650010925
THANK YOU
Email: Support@skillfinlearning.com
Mobile: 9650010925