Min and max unique and duplicate values using array formula in excel
Question: How do I get the largest and smallest unique and duplicate value?
Answer:
Max duplicate value, formula in C22:
Min duplicate value, formula in C24:
Max unique value, formula in C26:
Min unique value, formula in C28:
Named ranges
List (A2:A20)
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:
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
MIN(number1,[number2])
Returns the smallest number in a set of values. Ignores logical values and text
COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given condition
MAX(number1,[number2],)
Returns the largest value in a set of values. Ignores logical values and text.
Related posts:
Filter duplicate rows and sort by date using array formula in excel
Extract unique values from a range using array formula in excel
Filter unique values from a range using array formula in excel
Comparing two columns and sum unique values using array formula in excel
Recommended categories
How to find Min and Max numeric values in a range of cells that have duplicate numbers and blanks, but only want to find the Min and Max on the largest/top 100 non-duplicate values.
Marc,
read post:
Find max unique value from a range that have duplicate numbers and blanks
[...] Excel, Search/Lookup, Sort values, table on Nov.20, 2012. Email This article to a Friend Marc asks:How to find Min and Max numeric values in a range of cells that have duplicate numbers and blanks, [...]