Thread: analysis data into range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default analysis data into range
Try the FREQUENCY function.
--
David Biddulph

"SYL" wrote in message
...
Any one know how to convert data into range?

Like
A 18
B 25
C 120

Then
Range 0-100: 43 (i.e. A+B)
Range 100-200: 120 (i.e.C)

There are more than 8 range, therefore if function might not work
effectively



Reply With QuoteReply With Quote