1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Trying to find number of values with same frequency as mode

I’m trying to write a formula that outputs the number of values which occur in a range of cells the same number of times as the mode, without needing to output an array first. Basically, if the mode is 5, and 5 shows up 13 times in the range, but 3 also shows up 13 times, the formula will output “2”.

This is what I’ve come up with, which I have constructed step by step, and all of the steps work as separate formulas referencing each other, but when I put it all together, I just get an error:

=COUNTIF(FREQUENCY(C2:C79, UNIQUE(C2:C79, FALSE, FALSE)), MAX(FREQUENCY(C2:C79, UNIQUE(C2:C79, FALSE, FALSE))))

What am I missing/doing wrong?

submitted by /u/fiisntannoying
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article