Tricky formula required, so need help!

mevetts

mevetts

Board Regular
Joined
Dec 30, 2005
Messages
75
Hi

I have 2 sheets.

The first sheet has student names (each 4 rows apart), next to each name on a separate row is Late, No folder, Absent. Next to these teachers are putting an / when required and I use a countif formula to total the number of entries for each one.

The second sheet has student names directly under each other and then in three columns across I have the Late, No folder, Absent headers.

I need to copy the totals data from sheet one to sheet two for each student.

However, I have over 100 students and want to be able to copy the formula across and down the sheet!

Is there any way of writing a formula that can do this?

Thank you for your help.

P.S. I would attached the spreadsheet, but can't seem to figure out how to do it?
 
Sort by date Sort by votes
Sheet 1

<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>

<table class="tableizer-table">
<tr class="tableizer-firstrow"><th>Set</th><th>Name</th><th>Total</th><th> </th></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Adams, Charlotte</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Ade-Odiachi, Oluwatobiloba (Tobi)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Andrews, Isabella</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Asuzu, Akunna</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Bailey, Cornelius (Humphrey)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Baker, Sam</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Barnes, Benedict (Beno)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Bengtsson, Amalie</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Blumer, Saskia</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Brand, Callum</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Brothwood, Harry</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Brown, Rupert</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec C 1</td><td>Bruce, Benjamin (Ben)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Burgess, Dominic</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec B 1</td><td>Burgon, Daniel</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Buylakova, Anna</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec B 1</td><td>Caine, Charles (Charlie)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Chambers, Hugo</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Chan, Chit To (Sidney)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Chen, Yung Hung (Jeremy)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Chess, Felix</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Collinson, Amy</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Davidson, Danial</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec B 1</td><td>Denne, Amelia</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec C 1</td><td>Dowley, Seth</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Drungilaite, Ruta</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 2</td><td>Duncliffe-Vines, Alexander (Alex)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Edwards, Hadrian (Glenn)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Edwards, Rhys</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Godlevskiy, Evgeny</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Goff, Gabriella (Gabi)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Gordeev, Alexey</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Gunn, Georgina (Georgie)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Gusak, Andrey</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Hayward, Toby</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Hil, Ernest</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Hughes, James</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec C 1</td><td>Humphreys, Christian</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Isherwood, Thomas (Tom)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Jamieson-Black, Jock</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Jaques, Duncan</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec C 1</td><td>Jones, Sam</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Kan, Chun Kit (Jason)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 2</td><td>Khan, Mehryar</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Kim, Jaeryeng</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 2</td><td>Kravchenko, Vadim</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec B 1</td><td>Lait, Henry</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Lau, Elliot</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Leung, Chun Yin (Savio)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Leung, Hau Ying (Megan)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec C 1</td><td>Lewis, Orlando</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Lowe, Jemima</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Luard, Harry</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Luksic, Tomas</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Lushington, Thomas (Tom)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Martin, William</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>McEvoy, Douglas</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Montagu, Adrian</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec B 1</td><td>Morgan, Alasdair</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Morgan, Alexander</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Muangkrachang, Tarin</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Mullenga-Moshi, Jordan</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 2</td><td>Mundy, Thomas</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Nicholson, Warwick</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Oliver, Ross</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Parker, Jack</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Parry, Jack</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Pemberton, Elena</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Pemberton, Laurence</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Perwaz, Azm-E-Ali</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Polyanskiy, Nikolay</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Pratt, Harry</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Price, Edwin</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Rankin, Edward</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Ribeiro, Kelvin</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec B 1</td><td>Roff-Stanion, Kier</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Roff-Stanion, Rowan</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Ross, Timothy (Angus)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Rozanov, Denys</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Sakaguchi, Eisuke</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Sawamiphakdi, Kullatorn (Guy)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Schreyeck, Nicolas</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Shackell, Lucy</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 2</td><td>Skinner, Joshua (Josh)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>Soames, Oliver</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec C 1</td><td>Sowerbutts, Rufus</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Stack, Elizabeth</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 1</td><td>Stannett, Harry</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec D 1</td><td>Tai, Keng Wai (Godwin)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 2</td><td>Tephabutra, Barama</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Tephabutra, Chai</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec B 1</td><td>Thompson, Rupert</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec D 2</td><td>Thornley, Oscar</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Vanner, Nicole</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>White, Benjamin (George)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec C 1</td><td>White, James</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec A 1</td><td>Wilkins, George</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec C 1</td><td>Williamson, Antonia</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>L6 Ec B 1</td><td>Woodward, Harriet</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>U6 Ec A 1</td><td>Yip, Ho Chun (Terry)</td><td>0</td><td>Late</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Missing Resources</td></tr>
<tr><td> </td><td> </td><td>0</td><td>Absent</td></tr></table>
 
Upvote 0
Sheet 2

<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>

<table class="tableizer-table">
<tr class="tableizer-firstrow"><th></th><th>Late</th><th>Missing Reources </th><th>Absent</th></tr>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>Adams, Charlotte</td><td> </td><td> </td><td> </td></tr>
<tr><td>Ade-Odiachi, Oluwatobiloba (Tobi)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Andrews, Isabella</td><td> </td><td> </td><td> </td></tr>
<tr><td>Asuzu, Akunna</td><td> </td><td> </td><td> </td></tr>
<tr><td>Bailey, Cornelius (Humphrey)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Baker, Sam</td><td> </td><td> </td><td> </td></tr>
<tr><td>Barnes, Benedict (Beno)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Bengtsson, Amalie</td><td> </td><td> </td><td> </td></tr>
<tr><td>Blumer, Saskia</td><td> </td><td> </td><td> </td></tr>
<tr><td>Brand, Callum</td><td> </td><td> </td><td> </td></tr>
<tr><td>Brothwood, Harry</td><td> </td><td> </td><td> </td></tr>
<tr><td>Brown, Rupert</td><td> </td><td> </td><td> </td></tr>
<tr><td>Bruce, Benjamin (Ben)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Burgess, Dominic</td><td> </td><td> </td><td> </td></tr>
<tr><td>Burgon, Daniel</td><td> </td><td> </td><td> </td></tr>
<tr><td>Buylakova, Anna</td><td> </td><td> </td><td> </td></tr>
<tr><td>Caine, Charles (Charlie)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Chambers, Hugo</td><td> </td><td> </td><td> </td></tr>
<tr><td>Chan, Chit To (Sidney)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Chen, Yung Hung (Jeremy)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Chess, Felix</td><td> </td><td> </td><td> </td></tr>
<tr><td>Collinson, Amy</td><td> </td><td> </td><td> </td></tr>
<tr><td>Davidson, Danial</td><td> </td><td> </td><td> </td></tr>
<tr><td>Denne, Amelia</td><td> </td><td> </td><td> </td></tr>
<tr><td>Dowley, Seth</td><td> </td><td> </td><td> </td></tr>
<tr><td>Drungilaite, Ruta</td><td> </td><td> </td><td> </td></tr>
<tr><td>Duncliffe-Vines, Alexander (Alex)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Edwards, Hadrian (Glenn)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Edwards, Rhys</td><td> </td><td> </td><td> </td></tr>
<tr><td>Godlevskiy, Evgeny</td><td> </td><td> </td><td> </td></tr>
<tr><td>Goff, Gabriella (Gabi)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Gordeev, Alexey</td><td> </td><td> </td><td> </td></tr>
<tr><td>Gunn, Georgina (Georgie)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Gusak, Andrey</td><td> </td><td> </td><td> </td></tr>
<tr><td>Hayward, Toby</td><td> </td><td> </td><td> </td></tr>
<tr><td>Hil, Ernest</td><td> </td><td> </td><td> </td></tr>
<tr><td>Hughes, James</td><td> </td><td> </td><td> </td></tr>
<tr><td>Humphreys, Christian</td><td> </td><td> </td><td> </td></tr>
<tr><td>Isherwood, Thomas (Tom)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Jamieson-Black, Jock</td><td> </td><td> </td><td> </td></tr>
<tr><td>Jaques, Duncan</td><td> </td><td> </td><td> </td></tr>
<tr><td>Jones, Sam</td><td> </td><td> </td><td> </td></tr>
<tr><td>Kan, Chun Kit (Jason)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Khan, Mehryar</td><td> </td><td> </td><td> </td></tr>
<tr><td>Kim, Jaeryeng</td><td> </td><td> </td><td> </td></tr>
<tr><td>Kravchenko, Vadim</td><td> </td><td> </td><td> </td></tr>
<tr><td>Lait, Henry</td><td> </td><td> </td><td> </td></tr>
<tr><td>Lau, Elliot</td><td> </td><td> </td><td> </td></tr>
<tr><td>Leung, Chun Yin (Savio)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Leung, Hau Ying (Megan)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Lewis, Orlando</td><td> </td><td> </td><td> </td></tr>
<tr><td>Lowe, Jemima</td><td> </td><td> </td><td> </td></tr>
<tr><td>Luard, Harry</td><td> </td><td> </td><td> </td></tr>
<tr><td>Luksic, Tomas</td><td> </td><td> </td><td> </td></tr>
<tr><td>Lushington, Thomas (Tom)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Martin, William</td><td> </td><td> </td><td> </td></tr>
<tr><td>McEvoy, Douglas</td><td> </td><td> </td><td> </td></tr>
<tr><td>Montagu, Adrian</td><td> </td><td> </td><td> </td></tr>
<tr><td>Morgan, Alasdair</td><td> </td><td> </td><td> </td></tr>
<tr><td>Morgan, Alexander</td><td> </td><td> </td><td> </td></tr>
<tr><td>Muangkrachang, Tarin (Tarin (Kong))</td><td> </td><td> </td><td> </td></tr>
<tr><td>Mullenga-Moshi, Jordan</td><td> </td><td> </td><td> </td></tr>
<tr><td>Mundy, Thomas</td><td> </td><td> </td><td> </td></tr>
<tr><td>Nicholson, Warwick</td><td> </td><td> </td><td> </td></tr>
<tr><td>Oliver, Ross</td><td> </td><td> </td><td> </td></tr>
<tr><td>Parker, Jack</td><td> </td><td> </td><td> </td></tr>
<tr><td>Parry, Jack</td><td> </td><td> </td><td> </td></tr>
<tr><td>Pemberton, Elena</td><td> </td><td> </td><td> </td></tr>
<tr><td>Pemberton, Laurence</td><td> </td><td> </td><td> </td></tr>
<tr><td>Perwaz, Azm-E-Ali</td><td> </td><td> </td><td> </td></tr>
<tr><td>Polyanskiy, Nikolay</td><td> </td><td> </td><td> </td></tr>
<tr><td>Pratt, Harry</td><td> </td><td> </td><td> </td></tr>
<tr><td>Price, Edwin</td><td> </td><td> </td><td> </td></tr>
<tr><td>Rankin, Edward</td><td> </td><td> </td><td> </td></tr>
<tr><td>Ribeiro, Kelvin</td><td> </td><td> </td><td> </td></tr>
<tr><td>Roff-Stanion, Kier</td><td> </td><td> </td><td> </td></tr>
<tr><td>Roff-Stanion, Rowan</td><td> </td><td> </td><td> </td></tr>
<tr><td>Ross, Timothy (Angus)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Rozanov, Denys</td><td> </td><td> </td><td> </td></tr>
<tr><td>Sakaguchi, Eisuke</td><td> </td><td> </td><td> </td></tr>
<tr><td>Sawamiphakdi, Kullatorn (Guy)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Schreyeck, Nicolas</td><td> </td><td> </td><td> </td></tr>
<tr><td>Shackell, Lucy</td><td> </td><td> </td><td> </td></tr>
<tr><td>Skinner, Joshua (Josh)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Soames, Oliver</td><td> </td><td> </td><td> </td></tr>
<tr><td>Sowerbutts, Rufus</td><td> </td><td> </td><td> </td></tr>
<tr><td>Stack, Elizabeth</td><td> </td><td> </td><td> </td></tr>
<tr><td>Stannett, Harry</td><td> </td><td> </td><td> </td></tr>
<tr><td>Tai, Keng Wai (Godwin)</td><td> </td><td> </td><td> </td></tr>
<tr><td>Tephabutra, Barama</td><td> </td><td> </td><td> </td></tr>
<tr><td>Tephabutra, Chai</td><td> </td><td> </td><td> </td></tr>
<tr><td>Thompson, Rupert</td><td> </td><td> </td><td> </td></tr>
<tr><td>Thornley, Oscar</td><td> </td><td> </td><td> </td></tr>
<tr><td>Vanner, Nicole</td><td> </td><td> </td><td> </td></tr>
<tr><td>White, Benjamin (George)</td><td> </td><td> </td><td> </td></tr>
<tr><td>White, James</td><td> </td><td> </td><td> </td></tr>
<tr><td>Wilkins, George</td><td> </td><td> </td><td> </td></tr>
<tr><td>Williamson, Antonia</td><td> </td><td> </td><td> </td></tr>
<tr><td>Woodward, Harriet</td><td> </td><td> </td><td> </td></tr>
<tr><td>Yip, Ho Chun (Terry)</td><td> </td><td> </td><td></td></tr></table>
 
Upvote 0
A not so quick but dirty way. Copy sheet 1 into sheet 2. Assuming your data is in A:D, put in your headings for late, missing resources and absent in E,F & G. In the first line with a student name (here assumed to be row 3) use =C3, =C4 and =C5 in row 3 E, F and G to get the totals all on one line. Then select E3:G6 and drag down. Copy e:G and paste values. Delete columns C & D. Insert a new column A and number down consecutivelt to preserve the order. Sort on column B. Delete blank rows. sort back on column A to get the original order. Delete column A.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Dynamic Tab Reference and dynamic cell reference in a formula
Replies
3
Views
116
kvsrinivasamurthy
K
N
  • Question Question
VBA to add title from formula to a save as name
Replies
0
Views
232
NKUNZI
N
L
  • Question Question
How to create a column that adds cells with a cell in common
Replies
6
Views
123
Fluff
Fluff
A
  • Question Question
Automate Attendance Marking Based on Daily Schedule in Excel
Replies
1
Views
389
Peter_SSs
Peter_SSs
J
  • Solved
Excel VBA Help
2 3 4
Replies
36
Views
1K
Alex Blakenburg
A

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top