View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Eng Teng Eng Teng is offline
external usenet poster
 
Posts: 6
Default Create a table from raw data

Raw Data

Total Time(Minutes)
5.4
6.5
5.8
8.1
5.6
6.2
4.2
5.1
6.1

From the above raw data how do I create a table as below ?

Total Time Range(Minutes) No of count
< 4 0
4.0 - 4.9 1
5.0 - 5.9 4
6.0 - 6.9 3
7 1


Total 9

Regards,
Tee