how can you make the computer automatically find all numbers on excel that is repeated the most using the mode function, for me Excel always only shows me one number ,can anyone please help me?
2007-02-26 13:53:28 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
ok this time it was ok because there were only like what 40 data points for me to look at, but surely when the data collection gets huge, i'm taking in the thousands, there should be a better way to organize that data to find more then several modes in a data collection then listing them in order and then scanning them twice and three times.... if Microsoft did not include this in their porgram they surely must be big idiots... and i'm not just talking about the excel software....
2007-02-27 16:01:06 · update #1
I can see somthing that we can do to get the list of most repeated numbers, either in functions or using macro
mail me here in Y! Answers if you are interesting
Enjoy my profile, I am the VBAXLMan
2007-02-26 20:08:43 · answer #1 · answered by Anonymous · 0⤊ 0⤋
A simple workaround solution to your problem would be to sort your data (Sort... under the Data menu). That way if, for example, the mode is 23, all the records with 23 will be together in successive rows.
2007-02-27 15:24:28 · answer #2 · answered by Joliet Jake 3 · 0⤊ 0⤋
Countif would be more useful in your case..
2007-02-26 23:19:24 · answer #3 · answered by unnga 6 · 0⤊ 1⤋