Count unique distinct text values in a range in excel
Array formula in D14:
Alternative array formula:
Array formula in D15:
Named ranges
tbl (B5:F11)
What is named ranges?
How to customize the formula to your excel spreadsheet
Change the named range.
Download excel example file.
Count unique distinct text values in a range.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given condition
IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
ISTEXT(value)
Checks whether a value is text, and returns TRUE or FALSE
SUM(number1,[number2],)
Adds all the numbers in a range of cells
FREQUENCY(data_array, bins_array)
Calculates how often values occur within a range of values and then returns a vertical array of numbers having one more element than Bins_array.
Related posts:
Create a unique distinct text list from a range containing both numerical and text values in excel
Count unique text values in a range containing both numerical and text values
Filter unique text values from a range containing both numerical and text values in excel
Filter text values existing in range 1 but not in range 2 using array formula in excel
Extract duplicate text values from a range containing both numerical and text values in excel
Recommended categories
Wow, what a useful post! This is a great breakdown of how to count unique distinct values. The Excel community on Facebook could benefit from your knowledge and expertise. Check it out at http://www.facebook.com/office
Cheers,
Andy
MSFT Office Outreach Team
Thank you for your kind words! I´ll definitely check it out.
Oscar, your blogs are definitely one of kind! You have some great tutorials.
Its amazing how you construct those awesome array formulas.... Please post your articles everyday! lol!
No problem Oscar. Keep up the great posts!
Best,
Andy
MSFT Office Outreach Team