View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phillip Olan'g Phillip Olan'g is offline
external usenet poster
 
Posts: 1
Default Concentration Analysis

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