anthonyexcel
Active Member
- Joined
- Jun 10, 2011
- Messages
- 258
- Office Version
- 365
- Platform
- Windows
I have about 40,000 rows of data on sheet1 like below. What I need to do is to give a summary of grade level on sheet2. Please see below data.
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<tbody>
</tbody>
So that the data looks like this:
<tbody>
</tbody>
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
Grade | Test Level | # |
---|---|---|
3 | ||
1 | 17 | |
2 | 10 | |
3 | 6 | |
4 | ||
1 | 20 | |
2 | 8 | |
3 | 3 | |
5 | ||
1 | 14 | |
2 | 9 | |
3 | 16 | |
6 | ||
1 | 16 | |
2 | 11 | |
3 | 6 | |
7 | ||
1 | 18 | |
2 | 11 | |
3 | 5 | |
8 | ||
1 | 18 | |
2 | 13 | |
3 | 3 | |
3 | ||
1 | 16 | |
2 | 10 | |
3 | 5 | |
4 | ||
1 | 15 | |
2 | 17 | |
3 | 4 |
<tbody>
</tbody>
So that the data looks like this:
Grade | Test Level | # |
---|---|---|
3 | 1 | 33 |
2 | 20 | |
3 | 11 | |
4 | 1 | 35 |
2 | 25 | |
3 | 7 | |
5 | 1 | 14 |
2 | 9 | |
3 | 16 | |
6 | 1 | 16 |
2 | 11 | |
3 | 6 | |
7 | 1 | 18 |
2 | 11 | |
3 | 5 | |
8 | 1 | 18 |
2 | 13 | |
3 | 3 |
<tbody>
</tbody>