Finding the lowest mode in a set of numbers

[Tonso]

Using Excel 2002, I am analyzing sets of numbers. One statistic Ii
look at is the Mode. If the set of numbers has more than 1 mode, how
can I get the Mode function to return the lowest Mode?
Thanks,
Tonso

 

[Gary''s Student]

See Harlan Groove's comment in:

http://www.microsoft.com/office/com...&p=1&tid=abcc6020-b02a-4790-96b4-6d1599f4611d

 

[PCLIVE]

Maybe this:

=MIN(C1:E1)

C1:E1 represents the cells that contain the given modes. Adjust this as
needed. This formula will return the smallest number between cells C1, D1,
and E1.

HTH,
Paul

 

[RagDyeR]

Try this *array* formula on a list in A1 to A20:

=MIN(IF(COUNTIF(A1:A20,A1:A20)=MAX(COUNTIF(A1:A20,A1:A20)),A1:A20))
--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Using Excel 2002, I am analyzing sets of numbers. One statistic Ii
look at is the Mode. If the set of numbers has more than 1 mode, how
can I get the Mode function to return the lowest Mode?
Thanks,
Tonso