Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

UNIQUE Function

How to Select Random Cells in Excel (5 Ways)

Sometimes you may need to select some random cells and show them in your Excel workbook. If you are in searching for a way to select random cells in ...

How to Create List of Unique Values from Multiple Sheets in Excel

Whenever working with Excel, you may need to work with data from multiple sheets. And there can be a repetition of values in those sheets. If you ...

How to Summarize a List of Names in Excel (5 Effective Ways)

There are lots of types, a person wishes to summarize a list of names in Excel. Due to space limitations, we can not discuss all of that here right ...

How to Create Summary Table in Excel (3 Easy Methods)

If you want to create a summary table in Excel, you have come to the right site. We have discussed several straightforward methods in this post to ...

How to Make Pie Chart by Count of Values in Excel

In this article, we are going to show you 2 methods to make a Pie Chart by the count of values in Excel. Download Practice Workbook Pie ...

[Fixed!] Excel Formulas Not Working on Another Computer (5 Solutions)

If your Excel formulas not working on another computer and you are looking for solutions, you have come to the right place. In this article, we will ...

How to Consolidate Data from Multiple Rows in Excel (4 Quick Methods)

In many cases, you may need to consolidate, merge or combine data. In Microsoft Excel, you can do such types of tasks in bulk and within seconds. ...

How to Group Similar Items in Excel (4 Common Ways)

If you are working with data or items of different categories in your  Excel worksheet, then you might need to group similar items in your Excel. ...

How to Create a Training Matrix in Excel (3 Easy Methods)

In this article, we will show you 3 methods of how to create a training Matrix in Excel. We’ll make the Matrix from a dataset for the first 2 ...

Random Selection from List with No Duplicates in Excel (5 Cases)

If you are looking for some of the easiest and most effective ways for random selection from a list with no duplicates in Excel, then you will find ...

How to Correct a Spill (#SPILL!) Error in Excel (7 Easy Fixes)

The #SPILL error is a widespread Excel problem that affects most individuals who utilize Office 365 Excel versions. The newest release of Excel under ...

Generate Random Numbers Without Duplicates in Excel (7 Ways)

When we work on an Excel spreadsheet, sometimes it is required to generate some random numbers. As the human mind is biased when people try to input ...

How to Combine Duplicate Rows in Excel without Losing Data (6 Methods)

We’re going to show you 6 methods of how to combine duplicate rows in Excel without losing data. To demonstrate our methods, we’ve taken a dataset ...

How to Find Duplicate Values in Excel Using Formula (9 Methods)

This article illustrates how to find duplicate values in excel using a  formula. It will be very tedious if you try to find duplicate values manually ...

How to Extract Unique Items from a List in Excel (10 Methods)

If you want to Extract Unique Items from a List in Excel, this article will be very helpful for you. Here, we will walk you through 10 easy methods ...