Hi Everyone, first time posting here.

So, I have a set of numbers ranging between 0.15 and 1.5, in 0.01 increments. What I'm trying to do is count the number of instances each number appears in the set (ex - how many times is 0.76 listed).

I've tried creating a frequency array using my data set and another column with the upper and lower banding values (so from .15 to 1.5 in 0.01 increments). The problem with this approach is that I'm getting a lot of zeros (ex. .36 might not appear in my data set, so the frequency array returns a value of zero for .36). These zeros are throwing off my analysis.

Is there any way to exclude/omit frequencies of zero from my analysis? Should I even be using a frequency array to solve this problem?

Thanks!
B