How do I find minimum duplicated values in a range?

  • Thread starter Thread starter SteveMcCready
  • Start date Start date
S

SteveMcCready

I am trying to find the lowest, duplicated value (min of 3 times) in a range
of numerical data. Is there a formula or combination of formulas that will
do this for me?
 
With data in column A in B1 enter:
=IF(COUNTIF($A$1:$A$100,A1) > 2,A1,"") and copy down
and then =MIN(B:B) is what you need.
 
Thanks, this works fine.

Gary''s Student said:
With data in column A in B1 enter:
=IF(COUNTIF($A$1:$A$100,A1) > 2,A1,"") and copy down
and then =MIN(B:B) is what you need.
Click to expand...
 
Back
Top