| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find minimum duplicated values in a range?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find minimum duplicated values in a range?
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. -- Gary''s Student - gsnu200794 "SteveMcCready" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find minimum duplicated values in a range?
Thanks, this works fine.
"Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200794 "SteveMcCready" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of minimum values in a Range. | Excel Discussion (Misc queries) | |||
| Duplicates are GOOD: How to find the most duplicated values? | Excel Worksheet Functions | |||
| find minimum of range based on multiple criteria | Excel Worksheet Functions | |||
| To find duplicated values in a range | Excel Worksheet Functions | |||
| How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) | |||
Linear Mode
