Question: How do I get the largest and smallest unique and duplicate value?
Max duplicate value, formula in C22:
Min duplicate value, formula in C24:
Max unique value, formula in C26:
Min unique value, formula in C28:
What is named ranges?
How to implement array formula to your workbook
Change named range.
Download excel example file.
Min and max unique and duplicate values.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Returns the smallest number in a set of values. Ignores logical values and text
Counts the number of cells within a range that meet the given condition
Returns the largest value in a set of values. Ignores logical values and text.