Forum Discussion
excel sheet calculation of frequency
I am Not able to calculate frequency as every time I am using the formula =Freqeuncy(data array, bins array) I am always getting 0 as the result or if I am getting Some result than it is repeating for every values
2 Replies
=FREQUENCY(B2:B10,C2:C4)This formula works in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
- Nobody helping here as a (working) crystal ball
Could you post a sample of your data + the expected result at least please?
