UNIQUE Function Archives

How to Count Unique Values in Excel with Multiple Criteria

Jan 25, 2023 Excel Formulas

In this article, we will show you some methods to count unique values in Excel worksheet based on different criteria. The Excel worksheet can be used ...

How to Use Excel LARGE Function with Duplicates in Excel

Jan 23, 2023 Excel Formulas

The LARGE function cannot identify the unique nth largest value if duplicates are available in an array. In this article, you will find the nth ...

Artificial Intelligence in Excel (4 Examples)

Jan 4, 2023 Data Analysis with Excel

Excel is a very powerful software for calculating and evaluating data. You can input your data and calculate the results along with different ...

How to Count Frequency of Unique Values in a Column in Excel

Jan 25, 2023 Excel Formulas

Excel by Microsoft is a user-friendly program that more than lives up to its stellar reputation. We can do various operations on a dataset thanks to ...

List of Dynamic Array Formulas in Excel (7 Practical Examples)

Mar 13, 2023 Excel Formulas

In this tutorial, I am going to share with you 7 practical list of dynamic array formulas in Excel. You can easily apply these functions to perform a ...

How to Use Excel DGET with Dynamic Criteria (with Precise Steps)

Feb 8, 2023 Excel Formulas

Have you ever wondered how to apply the DGET function of Excel for multiple dynamic criteria? The DGET function of Microsoft Excel is one of the ...

[Fixed!] Error Messages in Excel (10 Practical Solutions)

Jan 4, 2023 Excel Basics

Without hesitation, Microsoft Excel is one of the most compelling computer software you can use. Using Excel's tools and functions, we can do an ...

How to Randomize a List in Excel Without Duplicates (4 Ways)

Feb 8, 2023 Excel Basics

Certainly, Microsoft Excel excels at arranging and manipulating data. Now, it is a well-known fact that Excel has numerous dedicated functions to ...

How to Create Real Time Currency Converter In Excel

Feb 28, 2023 Excel Formulas

In this tutorial, I am going to share with you 2 effective ways to create a real-time currency converter in excel. You can easily apply these methods ...

How to Create Array Formula in Excel (10 Suitable Examples)

Feb 12, 2023 Excel Basics

If you are looking for ways to create an array formula in Excel, then this article is for you. After going through this article, you will get 10 ...

Excel VLOOKUP to Return Multiple Values in One Cell Separated by Comma

Feb 9, 2023 Excel Formulas

This article illustrates how to look up vertically using VLOOKUP and return multiple values in one cell in excel separated by a comma. Excel has ...

How to Use VLOOKUP with CHOOSE Function in Excel

Dec 20, 2022 Excel Formulas 2

Excel Formulas have benefitted us with solving many complex calculations in large datasets. Among them, the VLOOKUP function is widely used for table ...

How to Calculate Monthly Average from Daily Data in Excel

Dec 20, 2022 Excel Formulas

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default ...

How to Apply VLOOKUP with Multiple Criteria Using the CHOOSE Function

Dec 19, 2022 Excel Formulas

While working in Excel, we often need to find a value by applying the VLOOKUP function with multiple criteria using the CHOOSE function. VLOOKUP ...

How to Apply SUMIFS with INDEX MATCH for Multiple Columns and Rows

Feb 19, 2023 Excel Formulas

While working in Excel, we often need to do some conditional sums, and to do this we can use the SUMIFS function along with the combination of INDEX ...