Spreadsheet: 137308d1327054273-needing-to-find-ways-of-automating-simple-processes-mrc-attendance-sample-1-
Sheet: Notes

Notes |  |  |  |  |  |  | Last Name | First Name
I have extracted unique Last + 1st names
using Data/sort & filter/advanced to do the
extraction.  I then sorted the list, to help identify
typos and mis-spellings. You will note that many
of the  names are repeated, with just typo's and
spelling mistakes.  The very 1st 2 last names have |  |  |  |  |  |  | Last Name | First Name
a space in front of them (from your data) |  |  |  |  |  |  | Messing | [NAME]
 |  |  |  |  |  |  | Young | Dasean
I have applied a filter to your data page |  |  |  |  |  |  | Adams | Kahron
to help with correcting mis-spellings and |  |  |  |  |  |  | Adams | Raullo
incorrect times eg row 739 "time in" |  |  |  |  |  |  | Adams | Roullo
 |  |  |  |  |  |  | Akil | Malik
Once you have all the names corrected and created |  |  |  |  |  |  | [NAME] | [NAME]
a "master names list", re-do the extraction and |  |  |  |  |  |  | [NAME] | Nehemiah
then replace the names on the "names page" with |  |  |  |  |  |  | [NAME] | [NAME]
the new "master list".  This list is also being |  |  |  |  |  |  | Ashia | Smith
used to validate future entries and help prevent |  |  |  |  |  |  | Avant | Blessing
typos and spelling mistakes.  If you have a new |  |  |  |  |  |  | Bachemin | Ruby
name, add it to the "master list" so that it will |  |  |  |  |  |  | Baston | Jessica
be included in the validation list |  |  |  |  |  |  | Baston | [NAME]
 |  |  |  |  |  |  | Baylor | Muhaundus
I have modified your "time" Calc in col G |  |  |  |  |  |  | Beal | Previn
so that it adds both sets of times together, |  |  |  |  |  |  | Bell | [NAME]
it ignores any entries where the "to" time |  |  |  |  |  |  | Bell | Eddie
is not entered |  |  |  |  |  |  | Bess | Terrell
 |  |  |  |  |  |  | Betts | Tre
The "names" sheet includes a summary |  |  |  |  |  |  | Blankumsee | Jack'ara
based on what you asked for, including |  |  |  |  |  |  | Booker | Mikale
totals at the bottom  Once you have corrected |  |  |  |  |  |  | [NAME] | [NAME]
the names, the list will be much shorter |  |  |  |  |  |  | Bria | [NAME]
 |  |  |  |  |  |  | Britton | Briona
Hope this helps, let me know if you need any |  |  |  |  |  |  | [NAME] | Shawna
other summary from this |  |  |  |  |  |  | [NAME] | Shanea
 |  |  |  |  |  |  | Brooks | [NAME]
 |  |  |  |  |  |  | [NAME] | Aisha
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Jonnell
 |  |  |  |  |  |  | [NAME] | Ricky
 |  |  |  |  |  |  | [NAME] | Jonnel
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Pauline
 |  |  |  |  |  |  | [NAME] | Cameron
 |  |  |  |  |  |  | [NAME] | Adreion
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Bryant | Adoria
 |  |  |  |  |  |  | Bryant | Adoria
 |  |  |  |  |  |  | Bryant | Kherbii
 |  |  |  |  |  |  | Bryant | Duane
 |  |  |  |  |  |  | [NAME] | Jajuan
 |  |  |  |  |  |  | [NAME] | Kamari
 |  |  |  |  |  |  | Butler | [NAME]
 |  |  |  |  |  |  | Byrd | Terrance
 |  |  |  |  |  |  | Caleb | Smith
 |  |  |  |  |  |  | [NAME] | Niyah
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Toni
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Champion | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Cleveland | Maxwell
 |  |  |  |  |  |  | Cleveland | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Greg
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Cordell
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Cooper | Remico
 |  |  |  |  |  |  | Craddock | Shamia
 |  |  |  |  |  |  | D"Agostino | Isabel
 |  |  |  |  |  |  | D'Agostino | Isabel
 |  |  |  |  |  |  | D'Agostino | [NAME]
 |  |  |  |  |  |  | D'Agostino | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Daniels | Jajuan
 |  |  |  |  |  |  | Davenport | [NAME]
 |  |  |  |  |  |  | Davenport | Cristian
 |  |  |  |  |  |  | Davenport | Christian
 |  |  |  |  |  |  | [NAME] | Marcus
 |  |  |  |  |  |  | [NAME] | Shawn
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Ramon
 |  |  |  |  |  |  | Daytona-Summerhill | Kariah
 |  |  |  |  |  |  | Dobbins | [NAME]
 |  |  |  |  |  |  | Drake | Luther
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Dyer | [NAME]
 |  |  |  |  |  |  | Dyer | Shawn
 |  |  |  |  |  |  | [NAME] | Smith
 |  |  |  |  |  |  | [NAME] | Alexis
 |  |  |  |  |  |  | Edwards | [NAME]
 |  |  |  |  |  |  | Edwards | [NAME]
 |  |  |  |  |  |  | Edwards | [NAME]
 |  |  |  |  |  |  | Edwards | [NAME]
 |  |  |  |  |  |  | Ellery | [NAME]
 |  |  |  |  |  |  | Ellery | [NAME]
 |  |  |  |  |  |  | Ellery | Jonathon
 |  |  |  |  |  |  | Elmer | Adriane
 |  |  |  |  |  |  | Erkins | [NAME]
 |  |  |  |  |  |  | Erkins | Kiendre
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Evans | Janell
 |  |  |  |  |  |  | Evans | Keyvontae
 |  |  |  |  |  |  | Evans | Jannel
 |  |  |  |  |  |  | Ferguson | Tevin
 |  |  |  |  |  |  | Ferrier | Raishel
 |  |  |  |  |  |  | Fields | [NAME]
 |  |  |  |  |  |  | [NAME] | Drequan
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Franklin | Quantez
 |  |  |  |  |  |  | [NAME] | Quincy
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | French | [NAME]
 |  |  |  |  |  |  | Garland | Jahshayiah
 |  |  |  |  |  |  | [NAME] | Jayvon
 |  |  |  |  |  |  | Gentry | Jahkeel
 |  |  |  |  |  |  | Giles | Kenny
 |  |  |  |  |  |  | Glover | Cameron
 |  |  |  |  |  |  | [NAME] | Nila
 |  |  |  |  |  |  | Greene | [NAME]
 |  |  |  |  |  |  | Griffin | Jeremy
 |  |  |  |  |  |  | [NAME] | Dashawn
 |  |  |  |  |  |  | [NAME] | Travale
 |  |  |  |  |  |  | [NAME] | DaSean
 |  |  |  |  |  |  | Hargrove | [NAME]
 |  |  |  |  |  |  | Hargrove | Arion
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Carløs
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Hawkins | [NAME]
 |  |  |  |  |  |  | Hawkins | Yoshua
 |  |  |  |  |  |  | Hawkins | Empress
 |  |  |  |  |  |  | Heard | [NAME]
 |  |  |  |  |  |  | Heard | Marvell
 |  |  |  |  |  |  | Heard | Marvele
 |  |  |  |  |  |  | Heard | Cyncere
 |  |  |  |  |  |  | Herring | [NAME]
 |  |  |  |  |  |  | Higgind | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Hischack | Tyler
 |  |  |  |  |  |  | [NAME] | Tyler
 |  |  |  |  |  |  | Hollaway | Trevon
 |  |  |  |  |  |  | Holloway | Malik
 |  |  |  |  |  |  | Holston | Jasean
 |  |  |  |  |  |  | Hooks | Leeron
 |  |  |  |  |  |  | Hooks | Rondell
 |  |  |  |  |  |  | Hudson | Detrek
 |  |  |  |  |  |  | Hudson | Dekter
 |  |  |  |  |  |  | Hudson | Decter
 |  |  |  |  |  |  | Isaacs | Stuart
 |  |  |  |  |  |  | Isabel | D'Agostino
 |  |  |  |  |  |  | [NAME] | Annette
 |  |  |  |  |  |  | [NAME] | Tyshawn
 |  |  |  |  |  |  | [NAME] | Hollis
 |  |  |  |  |  |  | [NAME] | Tshawn
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Erick
 |  |  |  |  |  |  | Jeffries | Jacquan
 |  |  |  |  |  |  | Jenkins | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Kaleel
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Madelyn
 |  |  |  |  |  |  | [NAME] | Madelin
 |  |  |  |  |  |  | [NAME] | Rayshawn
 |  |  |  |  |  |  | [NAME] | Madeline
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | Rayshame
 |  |  |  |  |  |  | [NAME] | Rashawn
 |  |  |  |  |  |  | [NAME] | Shianne
 |  |  |  |  |  |  | Jones | Quinten
 |  |  |  |  |  |  | Jones | TJ
 |  |  |  |  |  |  | Jones | Quiasha
 |  |  |  |  |  |  | [NAME] | Kaleel
 |  |  |  |  |  |  | [NAME] | Messing
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Kelow | Raymon
 |  |  |  |  |  |  | Kember | Roberta
 |  |  |  |  |  |  | [NAME] | Ingram
 |  |  |  |  |  |  | Kippers | Devonta
 |  |  |  |  |  |  | Landry | Lauren
 |  |  |  |  |  |  | [NAME] | Jaron
 |  |  |  |  |  |  | Lewis | Erin
 |  |  |  |  |  |  | Lewis | Tremaine
 |  |  |  |  |  |  | Lewsukul | Raiwin
 |  |  |  |  |  |  | Lewsukul | Beam
 |  |  |  |  |  |  | Luniewski | [NAME]
 |  |  |  |  |  |  | Luniewski | Mercer
 |  |  |  |  |  |  | Luniewski | Preston
 |  |  |  |  |  |  | Luniewski | Ina
 |  |  |  |  |  |  | Lyles | Trevon
 |  |  |  |  |  |  | [NAME] | Trevon
 |  |  |  |  |  |  | [NAME] | D'Agostino
 |  |  |  |  |  |  | Martin | [NAME]
 |  |  |  |  |  |  | Maye | Tyrone
 |  |  |  |  |  |  | Mayfield | Zhane
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | McNeil | Joi
 |  |  |  |  |  |  | McNeill | Joi
 |  |  |  |  |  |  | Merriland | Drico
 |  |  |  |  |  |  | Messing | Zachary
 |  |  |  |  |  |  | Messing | Zach
 |  |  |  |  |  |  | Messing | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Mincey | [NAME]
 |  |  |  |  |  |  | Montgomery | India
 |  |  |  |  |  |  | Montgomery | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Moore | Blake
 |  |  |  |  |  |  | Morris | [NAME]
 |  |  |  |  |  |  | Morris | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Nicholson | [NAME]
 |  |  |  |  |  |  | Noble | Haishia
 |  |  |  |  |  |  | O'Bryant | Nate
 |  |  |  |  |  |  | O'Farrell | Aidan
 |  |  |  |  |  |  | O'Farrell | Aiden
 |  |  |  |  |  |  | Parish | [NAME]
 |  |  |  |  |  |  | Pates | Tyisha
 |  |  |  |  |  |  | Pierce | Ellen
 |  |  |  |  |  |  | Piphus | Denzale
 |  |  |  |  |  |  | Price | Debresha
 |  |  |  |  |  |  | Price | Nyyear
 |  |  |  |  |  |  | [NAME] | Samantha
 |  |  |  |  |  |  | Rashid | [NAME]
 |  |  |  |  |  |  | Reed | Saveair
 |  |  |  |  |  |  | Reed | Saveir
 |  |  |  |  |  |  | Reese | Carmen
 |  |  |  |  |  |  | Richards | [NAME]
 |  |  |  |  |  |  | Richardson | [NAME]
 |  |  |  |  |  |  | Riggs | [NAME]
 |  |  |  |  |  |  | [NAME] | Devonte
 |  |  |  |  |  |  | Robb | Ronisha
 |  |  |  |  |  |  | [NAME] | Mikale
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Rucker | Brittany
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Sanders | Rashawn
 |  |  |  |  |  |  | Sanders | [NAME]
 |  |  |  |  |  |  | Schaller | [NAME]
 |  |  |  |  |  |  | Schloemer | [NAME]
 |  |  |  |  |  |  | Scott | [NAME]
 |  |  |  |  |  |  | Scott | Sedan
 |  |  |  |  |  |  | Scott | [NAME]
 |  |  |  |  |  |  | Sebron | Briana
 |  |  |  |  |  |  | Sharnika | [NAME]
 |  |  |  |  |  |  | Shelton | [NAME]
 |  |  |  |  |  |  | [NAME] | Sharnika
 |  |  |  |  |  |  | Shoemaker | [NAME]
 |  |  |  |  |  |  | Simm | [NAME]
 |  |  |  |  |  |  | Simpson | Armando
 |  |  |  |  |  |  | Sims | Trevon
 |  |  |  |  |  |  | Smith | Ashia
 |  |  |  |  |  |  | Smith | [NAME]
 |  |  |  |  |  |  | Smith | Aisha
 |  |  |  |  |  |  | Smith | Justin
 |  |  |  |  |  |  | Smith | caleb
 |  |  |  |  |  |  | Smith | Ayshia
 |  |  |  |  |  |  | Spears | [NAME]
 |  |  |  |  |  |  | Starkey | Amber
 |  |  |  |  |  |  | Steele | [NAME]
 |  |  |  |  |  |  | Steele | Sydney
 |  |  |  |  |  |  | Steinkamp | Samantha
 |  |  |  |  |  |  | Steinkamp | [NAME]
 |  |  |  |  |  |  | [NAME] | Dyer
 |  |  |  |  |  |  | Stivender | Reece
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Storms | Lance
 |  |  |  |  |  |  | [NAME] | Nathan
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Summerhill | Kariah
 |  |  |  |  |  |  | Tegtmeyer | [NAME]
 |  |  |  |  |  |  | Tegtmeyer | Isabelle
 |  |  |  |  |  |  | Terrell | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Thompson | Cyara
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | Tinker | [NAME]
 |  |  |  |  |  |  | Tinker | Jahdor
 |  |  |  |  |  |  | Tippet | Demetrius
 |  |  |  |  |  |  | [NAME] | Demetrius
 |  |  |  |  |  |  | Turner | December
 |  |  |  |  |  |  | Turner | [NAME]
 |  |  |  |  |  |  | Underwood | [NAME]
 |  |  |  |  |  |  | Underwood | Myesha
 |  |  |  |  |  |  | Urig | [NAME]
 |  |  |  |  |  |  | [NAME] | Bria
 |  |  |  |  |  |  | Walker | [NAME]
 |  |  |  |  |  |  | Ware | Gabe
 |  |  |  |  |  |  | Ware | [NAME]
 |  |  |  |  |  |  | Weibel | Justin
 |  |  |  |  |  |  | White | Kendall
 |  |  |  |  |  |  | White | [NAME]
 |  |  |  |  |  |  | White | [NAME]
 |  |  |  |  |  |  | White | [NAME]
 |  |  |  |  |  |  | White | [NAME]
 |  |  |  |  |  |  | White | Jimmyla
 |  |  |  |  |  |  | Wiles | Jordan
 |  |  |  |  |  |  | wiliams | chafonte
 |  |  |  |  |  |  | [NAME] | Chafonte
 |  |  |  |  |  |  | [NAME] | Chafonte
 |  |  |  |  |  |  | [NAME] | Nathan
 |  |  |  |  |  |  | [NAME] | Nate
 |  |  |  |  |  |  | [NAME] | Terrez
 |  |  |  |  |  |  | Willis | Tremaine
 |  |  |  |  |  |  | Wise | Heaven
 |  |  |  |  |  |  | Wood | [NAME]
 |  |  |  |  |  |  | Woods | [NAME]
 |  |  |  |  |  |  | Woods | [NAME]
 |  |  |  |  |  |  | Wyche | Destiny
 |  |  |  |  |  |  | Yisrael | Ta'area
 |  |  |  |  |  |  | Young | Dasean
 |  |  |  |  |  |  | Young | Dasean
 |  |  |  |  |  |  | Young | Briana
 |  |  |  |  |  |  | Young | Dashawn
 |  |  |  |  |  |  |  | Nathan
 |  |  |  |  |  |  |  | Luther