Link to home
Start Free TrialLog in
Avatar of Burly
Burly

asked on

Calculating 7 most common values.

I have a large number of cells containing numbers.
I have to calculate wich 7 numbers are most common among the others. I can calculate the first one ( the most common ) using MODE but the other 6 I need I have no idea.

Thx in advance.
Avatar of cri
cri
Flag of Switzerland image

How are these cells arranged ? Column or range ?
ASKER CERTIFIED SOLUTION
Avatar of bkpchs237
bkpchs237

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Burly
Burly

ASKER

The answer was great , thx :)