Spreadsheet: 811372d1672443571-how-to-consecutively-number-repeated-values-sampleexcelfile
Sheet: Employee List (2)

[NAME] | =LEFT([@[What I want the Position ID to be]],2) |  | =[@Location]&" "&[@[Position Name]] |  | =[@[Full position name]]&"-"&[@[formula to return numbering of Same Full Position Names]]
 | Location | Position Name | Full position name | formula to return numbering of Same Full Position Names | formula to concat b,c,d,e | formula to create Position ID | What I want the Position ID to be
 |  | Assistant Teacher |  |  |  |  | AF AT
 |  | Bus Driver |  |  |  |  | AF BD
 |  | C O T A |  |  |  |  | AF COTA
 |  | Educational Assistant |  |  |  |  | AF EA-1
 |  | Educational Assistant |  |  |  |  | AF EA-2
 |  | Educational Assistant |  |  |  |  | AF EA-3
 |  | Educational Assistant |  |  |  |  | AF EA-4
 |  | Educational Assistant |  |  |  |  | AF EA-5
 |  | Head Start Family Service Worker |  |  |  |  | AF HS FSW
 |  | Office Manager |  |  |  |  | AF OM
 |  | Speech Language Pathologist Assistant |  |  |  |  | AF SLPA
 |  | Teacher |  |  |  |  | AF T
 |  | Assistant Teacher |  |  |  |  | AL AT-1
 |  | Bus Driver |  |  |  |  | AL BD
 |  | Educational Assistant |  |  |  |  | [NAME]
 |  | Educational Assistant |  |  |  |  | AL EA-2
 |  | Educational Assistant |  |  |  |  | AL EA-3
 |  | Educational Assistant |  |  |  |  | AL EA-4
 |  | Bus Monitor |  |  |  |  | AL-BM
 |  | Head Start Family Service Worker |  |  |  |  | [NAME]
 |  | Office Manager |  |  |  |  | AL OM
 |  | Teacher |  |  |  |  | AL T
 |  | Assistant Teacher |  |  |  |  | BV AT-1
 |  | Assistant Teacher |  |  |  |  | BV AT-2
 |  | Bus Driver |  |  |  |  | BV BD
 |  | Educational Assistant |  |  |  |  | BV EA-1
 |  | Educational Assistant |  |  |  |  | BV EA-2
 |  | Educational Assistant |  |  |  |  | BV EA-3
 |  | Educational Assistant |  |  |  |  | BV EA-4
 |  | Educational Assistant |  |  |  |  | BV EA-5
 |  | Educational Assistant |  |  |  |  | [NAME]
 |  | Head Start Family Service Worker |  |  |  |  | BV HS FSW-1
 |  | Head Start Family Service Worker |  |  |  |  | BV HS FSW-2
 |  | [NAME] |  |  |  |  | [NAME]
 |  | Office Manager |  |  |  |  | BV OM
 |  | Occupational Therapist |  |  |  |  | BV OT
 |  | Speech Language Pathologist |  |  |  |  | BV SLP
 |  | Teacher |  |  |  |  | BV T-1
 |  | Teacher |  |  |  |  | BV T-2
 |  | Family Resource Specialist |  |  |  |  | BV/KM FRS
 |  | Head Start Assistant Teacher |  |  |  |  | EV AT-1 HS
 |  | Head Start Assistant Teacher |  |  |  |  | EV AT-2 HS
 |  | Assistant Teacher |  |  |  |  | EV AT-3
 |  | Assistant Teacher |  |  |  |  | EV AT-4
 |  | Head Start Bus Driver |  |  |  |  | EV BD-1 HS
 |  | Bus Driver |  |  |  |  | EV BD-2
 |  | Head Start Bus monitor |  |  |  |  | EV BM HS
 |  | Bus Monitor |  |  |  |  | EV BM-2
 |  | Educational Assistant |  |  |  |  | EV EA-1
 |  | Educational Assistant |  |  |  |  | EV EA-2
 |  | Educational Assistant |  |  |  |  | EV EA-3
 |  | Educational Assistant |  |  |  |  | EV EA-4
 |  | Educational Assistant |  |  |  |  | EV EA-5
 |  | Head Start Educational Assistant |  |  |  |  | EV [NAME]
 |  | Head Start Educational Assistant |  |  |  |  | EV EA-7 HS
 |  | Head Start Educational Assistant |  |  |  |  | EV EA-8 HS
 |  | Head Start Educational Assistant |  |  |  |  | EV EA-9 HS
 |  | Head Start Educational Assistant |  |  |  |  | EV EA-910 HS
 |  | Head Start Educational Assistant |  |  |  |  | EV EA-911 HS
 |  | Educational Assistant |  |  |  |  | EV EA-912
 |  | Family Support Corrdinator |  |  |  |  | EV FSC
 |  | Head Start Family Service Worker |  |  |  |  | EV FSW-1 HS
 |  | Head Start Family Service Worker |  |  |  |  | EV FSW-2 HS
 |  | Head Start Family Resource Specialist |  |  |  |  | EV HS FRS
 |  | Head Start Kitchen Worker |  |  |  |  | EV KW-2 HS
 |  | [NAME] |  |  |  |  | EV KW-2
 |  | Office Manager |  |  |  |  | EV OM-1
 |  | Head Start Kitchen Worker |  |  |  |  | EV KW-1 HS
 |  | Speech Language Pathologist |  |  |  |  | EV SLP
 |  | Speech Language Pathologist |  |  |  |  | EV SLP-2
 |  | Speech Language Pathologist Assistant |  |  |  |  | EV SLPA-1
 |  | Speech Language Pathologist Assistant |  |  |  |  | EV SLPA-2
 |  | Teacher |  |  |  |  | EV T-1
 |  | Teacher |  |  |  |  | EV T-2
 |  | Head Start Teacher |  |  |  |  | EV T-3 HS
 |  | Head Start Teacher |  |  |  |  | EV [NAME]
 |  | Teacher |  |  |  |  | EV T-5
 |  | Assistant Teacher |  |  |  |  | KM AT-1
 |  | Assistant Teacher |  |  |  |  | KM AT-2
 |  | Bus Driver / Educational Assistant |  |  |  |  | KM BD-1/EA-3
 |  | Bus Monitor |  |  |  |  | KM BM 1
 |  | Educational Assistant |  |  |  |  | KM EA-1
 |  | Educational Assistant |  |  |  |  | KM EA-2
 |  | Head Start Family Service Worker |  |  |  |  | KM HS FSW
 |  | [NAME] |  |  |  |  | KM KW
 |  | Office Manager |  |  |  |  | KM OM
 |  | speech language pathologist |  |  |  |  | KM SLP
 |  | Teacher |  |  |  |  | KM T
 |  | Maintanence |  |  |  |  | MAIN
 |  | Assistant Business Manager |  |  |  |  | RO ABM
 |  | Business Mananger |  |  |  |  | RO BM
 |  | Behavior Specialist |  |  |  |  | RO BS
 |  | Clerical Assistant |  |  |  |  | RO CA
 |  |  |  |  |  |  | RO CONSULT
 |  | Human Resource Specialist |  |  |  |  | RO HR
 |  | Head Start Program Manager |  |  |  |  | RO HSPM
 |  | Mental Health Consultant |  |  |  |  | RO MHC
 |  | Regional Director |  |  |  |  | RO RD
 |  | SpecialEd Program Manager |  |  |  |  | RO SPMG
 |  | Family Support Corrdinator |  |  |  |  | SV FSC-1
 |  | Speech Language Pathologist |  |  |  |  | SV SLP
 |  | Assistant Teacher |  |  |  |  | TH AT
 |  | Bus Driver / Safety Trainer |  |  |  |  | TH BD/ST
 |  | COTA |  |  |  |  | TH COTA
 |  | Educational Assistant |  |  |  |  | TH EA-1
 |  | Educational Assistant |  |  |  |  | TH EA-2
 |  | Educational Assistant |  |  |  |  | TH EA-4
 |  | Head Start Family Resource Specialist |  |  |  |  | TH FRS
 |  | Head Start Family Service Worker |  |  |  |  | TH FSW
 |  | Office Manager |  |  |  |  | TH OM
 |  | Teacher |  |  |  |  | TH T
 |  | Teacher |  |  |  |  | TH T