Most repetetive numbers in a range

[timmy]

Hi Everyone,

Does anyone know of a function that can give me the most repetetiv
number followed by the second most repetetive number and so on.... in
specified range of cells.

The Mode function just gives the most repetetive number, is i
possible to nest this function to give the second most repetetiv
number and the third most repetetive number ?

Eagerly awaiting your replies.

Regards,

Timm

 

[Alok Joshi]

Have you tried the Tools/Data Analysis/Histogram option

 

[timmy]

Hi Alok,

I don't have the Data Analysis option, can you please advise how I ca
get to this Histogram option ?

Regards,

Timmy

 

[Peo Sjoblom]

Assume you get first mode as

=MODE(A1:A10)

you put that formula in B1

Second mode is

=MODE(IF(A1:A10<>B1,A1:A10))

entered with ctrl + shift & enter

assume you put that formula in C1

third is

=MODE(IF((A1:A10<>B1)*(A1:A10<>C1),A1:A10))

entered with ctrl + shift & enter




--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Alok Joshi]

Timmy,

Go to Tools/Add Ins and check on Analysis Toolpack.

 

[timmy]

Hi Peo,

It worked, you're a genius, you've also taught me how to use CS
functions.

Thank you very much !

Cheers,

Timmy

*Assume you get first mode as

=MODE(A1:A10)

you put that formula in B1

Second mode is

=MODE(IF(A1:A10<>B1,A1:A10))

entered with ctrl + shift & enter

assume you put that formula in C1

third is

=MODE(IF((A1:A10<>B1)*(A1:A10<>C1),A1:A10))

entered with ctrl + shift & enter




--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom