Most repetetive numbers in a range

  • Thread starter Thread starter timmy
  • Start date Start date
T

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
 
Hi Alok,

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

Regards,

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
 
Hi Peo,

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

Thank you very much !

Cheers,

Timmy :)



Peo said:
*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
Click to expand...
 
Back
Top