'UNIQUE function' category
This article demonstrates a formula that creates a frequency distribution table from a multi-column cell range which is useful in […]
The UNIQUE function is a very versatile Excel function, it lets you extract both unique and unique distinct values and […]
This article demonstrates ways to sort numbers from smallest to largest ignoring duplicate numbers. Table of Contents SMALL function with […]
This article demonstrates how to distribute values into specific ranges with possible overlapping ranges. I have written articles about filter […]
This article demonstrates how to construct a formula that counts unique distinct values based on a condition. The image above […]
This article demonstrates formulas that extract duplicate values from a column, however, column D contains values that you don't want […]
This article demonstrates how to extract unique distinct values based on a condition and also sorted from A to z. […]
This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]
A drop-down list in Excel prevents a user from entering an invalid value in a cell. Entering a value that […]
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
This article demonstrates a formula that filters unique distinct single digits from a cell range containing numbers. Cell range B3:B6 […]
This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]
This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]
This article shows how to extract unique distinct values based on a condition applied to an adjacent column using formulas. […]
This article demonstrates two ways to calculate the number of times each word appears in a given range of cells. […]
This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]
Andre asks:I am trying to list people with the highest scores based on certain criteria. My data: column A B […]
This blog post describes how to create a list of unique words from a cell range. Unique words are all […]
This article demonstrates ways to extract unique distinct sorted from A to Z ignoring blanks, and based on a condition. […]
This article demonstrates how to create a list of dates based on multiple date ranges. Table of contents Convert date […]
Question: How to create unique distinct year and months from a long date listing (column A)? You can find the […]
Filtering unique distinct text values and sorting them based on the sum of adjacent values can easily be done by […]
A unique value is a value that only exists once in a list. A unique distinct list contains all cell values […]
What's on this page Unique distinct values sorted based on frequency (single column) Unique distinct values sorted based on frequency […]
This article demonstrates formulas that extract sorted unique distinct values from a cell range containing also blanks. Unique distinct values […]
Table of Contents How to find the largest duplicate number How to find the largest duplicate number - Excel 365 […]
The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]
This article describes two formulas that extract duplicates from a multi-column cell range, the first one is built for Excel […]
This webpage demonstrates formulas that merge three non-adjacent cell ranges. What's on this webpage Extract a list of duplicates from […]
The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]
Question: How do I extract a unique distinct list from three ranges or lists? The ranges are not necessarily adjacent […]
Question: I have two ranges or lists (List1 and List2) from where I would like to extract a unique distinct […]
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]
Table of Contents Filter unique distinct values based on a date range Filter unique distinct values based on a date […]
This article demonstrates a formula that sorts cell values by their frequency, in other words, how many times a value […]
Table of Contents Sum unique numbers Get Excel *.xlsx file Sum unique distinct numbers Get Excel *.xlsx file Sum number […]
The array formula in cell D3 extracts unique distinct values sorted A to Z, from column B to column D. […]
First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]
This article demonstrates ways to list unique distinct values in a cell range with multiple columns. The data is not […]
This article demonstrates formulas that extract unique distinct values and ignore blank empty cells. Table of contents Extract a unique […]
Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]