| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create chart using part of data table (data legend) | Charts and Charting in Excel | |||
| Create a toplist from data in table | Excel Discussion (Misc queries) | |||
| how to create a table given data... | Excel Discussion (Misc queries) | |||
| How do I create a one variable data table? | Excel Discussion (Misc queries) | |||
| How do I create a one variable data table? | Excel Discussion (Misc queries) | |||
Linear Mode
