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.
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.
How are these cells arranged ? Column or range ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The answer was great , thx :)