Hey, I need help sorting out student attendance data.
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>
For example, this is January Sheet.
Data is sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {mso-number-format:"\[h\]\:mm"; border:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {mso-number-format:"\[h\]\:mm"; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl75 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl77 {font-weight:700; text-align:left; vertical-align:middle; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl78 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl79 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl80 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl81 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl82 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>
<tbody>
</tbody>
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>I have another sheet which sums up all hours for each student. Also sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {font-weight:700; text-align:left; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {mso-number-format:"h\:mm\;\@"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl75 {mso-number-format:"Short Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>
<tbody>
</tbody>
How can I sort data alphabetically by student names so that monthly and total hours don't get messed up?
Thanks!
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>
For example, this is January Sheet.
Data is sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {mso-number-format:"\[h\]\:mm"; border:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {mso-number-format:"\[h\]\:mm"; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {mso-number-format:"\[h\]\:mm"; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl75 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}.xl77 {font-weight:700; text-align:left; vertical-align:middle; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl78 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl79 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl80 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl81 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl82 {mso-number-format:"Medium Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>
Name | #ID | Monday 01/01/18 | Tuesday 01/02/18 | Wednesday 01/03/18 | TOTAL | ||||||
Caroline | 01A | 9:00 AM | 4:00 PM | 7:00 | 9:00 AM | 4:00 PM | 7:00 | 9:00 AM | 4:00 PM | 7:00 | 21:00 |
Ben | 02A | 10:00 AM | 4:00 PM | 6:00 | 10:00 AM | 4:00 PM | 6:00 | 10:00 AM | 4:00 PM | 6:00 | 18:00 |
Denize | 03A | 11:00 AM | 4:00 PM | 5:00 | 11:00 AM | 4:00 PM | 5:00 | 11:00 AM | 4:00 PM | 5:00 | 15:00 |
Alex | 04A | 9:00 AM | 4:00 PM | 7:00 | 9:00 AM | 4:00 PM | 7:00 | 9:00 AM | 4:00 PM | 7:00 | 21:00 |
<tbody>
</tbody>
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style>I have another sheet which sums up all hours for each student. Also sorted by Column B (#ID)
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {border:.5pt solid windowtext;}.xl64 {border-top:1.0pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none;}.xl65 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;}.xl66 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl69 {font-weight:700;}.xl70 {font-weight:700; text-align:left; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl71 {font-weight:700; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl72 {font-weight:700; mso-number-format:"dddd\\ mm\/dd\/yy"; text-align:center; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl73 {color:windowtext; font-weight:700; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; vertical-align:middle; border:1.0pt solid windowtext; background:white; mso-pattern:black none;}.xl74 {mso-number-format:"h\:mm\;\@"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl75 {mso-number-format:"Short Time"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;}.xl76 {font-weight:700; mso-number-format:"\[h\]\:mm"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:white; mso-pattern:black none;}--></style>
Name | #ID | January | February | March | April | September | October | November | December | TOTAL |
Caroline | 01A | 21:00 | 22:00 | 15:00 | 22:00 | 17:00 | 15:00 | 22:00 | 15:00 | 149:00 |
Ben | 02A | 18:00 | 23:00 | 17:00 | 23:00 | 22:00 | 17:00 | 23:00 | 17:00 | 160:00 |
Denize | 03A | 15:00 | 20:00 | 19:00 | 20:00 | 8:00 | 19:00 | 20:00 | 19:00 | 140:00 |
Alex | 04A | 21:00 | 22:00 | 15:00 | 22:00 | 19:00 | 15:00 | 22:00 | 15:00 | 151:00 |
<tbody>
</tbody>
How can I sort data alphabetically by student names so that monthly and total hours don't get messed up?
Thanks!