I am trying to program the frequency function in excel with great difficulty. I am enter range for data followed by range for breaks, called bins. It gives me the first frequency number in my array correctly, but after that, nothing. I can't figure out if i need to enter the formula once for every bin, or just once, or copy and paste (fill down) or what. Will I get numbers displayed in their own cells or will the frequency numbers all show up in one cell separated by commas? Microsoft's Help is not at all clear on this. Imagine that.
Thanks much,
Lancerw