How do I find minimum duplicated values in a range?

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?
 
G

Gary''s Student

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.
 
S

SteveMcCready

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Range headings 0
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Help needed: Minimum value based upon either/or criteria 3
Select minimum with duplicate values to return column headings 3
Need to get minimum difference 1
Findiing highest and lowest in rows and columns 3
How do I find the minimum value in a range while ignoring zeros? 4

Top