|
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 |
Create a table from raw data
In B1 thru B5 enter:
=COUNTIF(A:A,"<4") =COUNTIF(A:A,"<4.9")-COUNTIF(A:A,"<4") =COUNTIF(A:A,"<5.9")-COUNTIF(A:A,"<5") =COUNTIF(A:A,"<6.9")-COUNTIF(A:A,"<6") =COUNTIF(A:A,"7") -- Gary''s Student - gsnu2007j "Eng Teng" wrote: 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 |
Create a table from raw data
Enter the below function into an adjacent cell, and then fill down:
=IF(A2="","",SUM($A$2:A2)-A2+1&IF(A2=1,""," - "&SUM($A$2:A2))) Regards, Ryan--- -- RyGuy "Gary''s Student" wrote: In B1 thru B5 enter: =COUNTIF(A:A,"<4") =COUNTIF(A:A,"<4.9")-COUNTIF(A:A,"<4") =COUNTIF(A:A,"<5.9")-COUNTIF(A:A,"<5") =COUNTIF(A:A,"<6.9")-COUNTIF(A:A,"<6") =COUNTIF(A:A,"7") -- Gary''s Student - gsnu2007j "Eng Teng" wrote: 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 |
| All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com