I have a list of data (about 2000 data points), and I need to "count" how many times each singular data point occurs within a range. For example, lets say I only have 4 data points as follows:
A=2%
B=6%
C=2%
D=4%
In this instance, I want excel to tell me that there are 2 occurences of a value between 0% and 2%, one occurence between 2.1% and 4%, and one occurence between 4.1% and 6%.
Clear as mud ? Thanks for your help. Yes, I know this is probably a very simple excel question, but I guess thats why I'm here - because I need help with the very simple.
mike in Calgary
A=2%
B=6%
C=2%
D=4%
In this instance, I want excel to tell me that there are 2 occurences of a value between 0% and 2%, one occurence between 2.1% and 4%, and one occurence between 4.1% and 6%.
Clear as mud ? Thanks for your help. Yes, I know this is probably a very simple excel question, but I guess thats why I'm here - because I need help with the very simple.
mike in Calgary