maximum repeated value
Here's one way using an ARRAY FORMULA*:
For a list of values in A1:A10
The max repeated value
B1: =MAX(IF(COUNTIF(A1:A10,A1:A10)1,A1:A10))
Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"markag" wrote:
I'm trying to create an excel formula to give me the maximum repeaded
value in a range of numbers.
example:
5 I need to know the maximum value that occurs more
then once.
5 In this case the number would be 8.
8 Would I be able to write a formula that can do
this, it really
5 would help me out.
1
9
8
|