•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#mode
#frequency
#COUNTIF
#values
#formula
#range of cells
#output
#UNIQUE
#error
#occurrence
#array
#output an array
#maximum