Forum Discussion
Chrisie
Dec 23, 2022Copper Contributor
Frequency function in Excel
Hello all! I'm trying to understand how FREQUENCY function works in Excel. I have the sample below. So does FREQUENCY work with ranges? Does it work with specific numbers? Can someone explain ...
Chrisie
Jan 03, 2023Copper Contributor
Thank you so much for your reply.
Can I ask, what happens if the data are not sorted?
For example:
Thank you so much
HansVogelaar
Jan 03, 2023MVP
The result is basically the same, except that the values in column D are now in a different order because the values in column C have been shuffled.