Re: Frequency Calc (Excel2000>)

Thx. I didn't realise that you can inverse the number and make it negative.

The reason for the post is just to get clarity on the dynamics of Frequency. I am using it from time to time and sometimes get thrown out with the bin array. The next example I set up from the help files and when it is set up as an array function, the bins will determine the categories of count. It is only here that it will determine a count of above a highest value. I suspect that it works because more numbers are provided to the function, and it can categorise the values then. See insert!

Thanx for the reply Hans. I got so involved in trying to modify the frequency calc, that I missed the rather obvious of subtracting the frequency result from the count of scores... <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> <img src=/S/blush.gif border=0 alt=blush width=15 height=15>