I need to figure something out on my sheet. The “mode” function tells you witch value repeats the most. I want to see if there is another value that repeats just as much. Also, I want to see what value repeats the second most.
Ex:
4
6
4
7
5
6
4
5
5
If I use the function: =mode(list). It will return, “4”. By using =countif((list),mode(list)) I see that that repeated 3 times.
I want a way to see that “5” also repeated 3 times and then that 6 is repeated 2 times.
Ex:
4
6
4
7
5
6
4
5
5
If I use the function: =mode(list). It will return, “4”. By using =countif((list),mode(list)) I see that that repeated 3 times.
I want a way to see that “5” also repeated 3 times and then that 6 is repeated 2 times.