you might look for FREQUENCY function in Help


On 16 Kwi, 08:44, Phillip Olan'g <Phillip
wrote:
I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below:

local equivalent
1096.68
6000
513.25
174.45
18000
53.86
399.74
118.73
1010.31
19316.81
8066.49
220000
28.92
1567614.68
206.56
667.75

My output should be:

Range * * * * * * * * * * * *No. * * * * * * * * * * * * Value
0 - 25,000 * * * * * * * * *4 * * * * * * * * * * * * * * 30,000
25, 001- 50,000 * * * *10 * * * * * * * * * * * * * 275,000