Currently I have the following formulas to show the most common number in series (H166) and 2nd most common number (H167)…..In cell H168 I want to create a formula to show the 3rd Most Common Value in series, but are having problems creating it.
CELL H166
=(MODE(H131:H165))
CELL H167
=MODE(IF(H131:H165<>MODE(H131:H165),H131:H165,""))
CELL H166
=(MODE(H131:H165))
CELL H167
=MODE(IF(H131:H165<>MODE(H131:H165),H131:H165,""))