Spreadsheet: 673165d1587224900-autofill-a-cell-based-on-an-adjacent-cell-example
Sheet: Input Data (Student Info)

ORGRAA | ON ORDERS LOCNM
TH
NB
NR
CC
KC
TB
KC
TH
HS
CC
CC
TH
TH
NB
AW
WL
GB
KR
KR
KC
TH
KR
GS
KC
TH
KC
TH
NB
TB
GH
G3
HS
GS
TH
NR
TB
TH
GS
TH
NB
TB
KR
GB
KC
GB
WL
KR
NR
WL
WL
OS
HS
CC
TB
GS
GS
NB
NB
NB
NB
WL
GB
KC
GB
KC
TH
KC
NB
AE
NR
WL
HS
TH
KC
NB
G3
NB
G3
NR
G3
LP
AE
KC
WL
OS
GB
NR
NB
NR
GH
GB
TH
GB
TB
FE
GH
KC
G3
TH
TB
CC
G3
GS
TH
CC
GS
GS
GS
TH
WL
OS
GS
TS
NB
NR
NB
HS
G3
G3
GS
K8
G3
KC
NB
WL
KC
HS
KR
KC
GS
KR
TH
GS
GS
GB
TB
CC
TH
AW
TH
KC
GS
TB
TH
G3
TH
NB
TB
WL
AW
LP
NR
KR
NR
GS
TB
HS
NR
NB
AW
CC
NB
TB
NB
GB
GB
TB
GB
TB
NR
OS
GS
TH
NR
CC
G3
NB
NR
GB
G3
GB
KC
TH
CC
NR
NB
CC
NB
GS
NB
NB
GS
GS
TH
NB
NB
KC
TB
HS
NR
CC
NB
TH
KC
NB
OS
OS
TH
G3
NB
OS
TH
TB
NR
GS
GB
NB
CC
TH
NB
CI
GH
NB
KC
NB
G3
K8
GS
NB
VE
OS
NR
GB
CC
GS
KC
KR
GS
NR
GS
GB
OS
WL
AW
GB
TB
TH
WL
14
AE
KR
K8
NB
CC
TB
TH
CI
GS
TH
NR
HS
CC
GS
WL
TH
GS
TH
GS
GB
TB
GS
CC
KC
KK
TH
GS
KC
G3
K8
G3
KC
VE
KC
LP
OS
NB
NB
GS
GH
AR
TH
CC
GS
NB
HS
TH
TH
CC
KC
NB
GB
KC
IV
NB
NR
TB
KC
KK
AW
KR
TH
GB
KC
NR
KR
NB
TB
GS
AE
LP
TH
TH
NB
TB
GS
NB
AE
NB
KR
NR
NR
NB
NB
LP
TH
KC
KR
AW
AH
AE
OS
G3
NB
NB
WL
HS
TH
NR
AE
CI
NR
KC
KU
G3
AW
WL
AE
GS
KC
OS
GB
GB
KR
TB
GB
OS
GS
GB
NR
AE
KC
TH
TB
NR
NR
AE
CC
GS
TB
KR
GB
GS
OS
TB
NB
G3
HS
WL
NB
KK
G3
G3
KC
TB
NR
CC
NR
JA
GS
CC
TH
AE
GS
NB
G3
GH
NR
KC
NB
CC
K8
OS
NR
GB
KR
NR
G3
NB
TH
HS
GS
GS
NR
MM
NR
NB
NB
TB
NR
NB
GB
NB
NB
GB
GS
NR
OS
KR
TH
TH
TH
AE
TB
G3
KC
HS
NB
GS
KC
AE
CC
KC
NB
HS
G3
CC
KC
TB
CC
G3
NB
LP
AE
AE
G3
CI
G3
NB
G3
VE
G3
CC
NB
TB
NB
GB
G3
KR
HS
G3
NR
TB
G3
TH
NB
G3
TB
TH
KC
NR
NB
NB
GG
NB
GS
WL
GS
TB
KC
NB
TB
GS
NB
MW
KC
GB
G3
NR
OS
KC
GB
NR
NB
GH
K9
CC
TH
KR
KR
NB
WL
GS
NR
FE
WL
KC
HS
AE
TB
OS
CC
AW
NB
CC
TH
AH
49
KR
GS
GS
WL
G3
NR
KC
NR
JA
G3
NR
CC
G3
HS
48
NB
OS
KR
FE
NR
GB
MW
CC
NR
WL
TH
OS
WL
VE
KR
GH
GB
NB
KC
G3
NB
KC
GS
KR
NB
NR
HS
NB
CC
GS
NR
KC
OS
CC
NB
WL
AW
OS
G3
GB
ME
HS
TH
GB
NB
KR
TH
GS
OS
NR
CC
WL
GB
TH
KR
NB
NR
TH
WL
CC
NR
G3
TH
CC
OS
GS
KC
WL
GB
OS
TH
NB
LP
KC
GS
NR
AE
GH
NR
HS
VE
GS
NB
JA
OS
NB
TB
TH
OS
TH
TB
GH
NB
OS
TH
AW
WL
TH
OS
NB
GS
GB
WL
AW
TH
NR
HS
GS
JA
G3
G3
GS
NR
CC
GB
G3
KC
CC
OS
GS
KC
GS
JA
NB
NB
CI
KU
FE
NB
HF
KC
GB
NR
VE
GB
TH
NB
TH
NR
NR
GS
NB
NR
NR
WL
G3
NR
WL
AW
KC
AE
TB
KC
NR
TH
TH
CC
CC
NB
VY
MM
GB
GS
JA
KC
IV
TB
KC
WL
VY
WL
GB
KC
KC
G3
KR
NB
CC
TH
G3
TB
K8
CC
CC
NB
WL
NB
CC
NB
TH
NB
GB
NB
NR
TH
HS
TH
HS
NB
TB
TB
KC
NB
TH
AW
JA
TH
GB
OS
GS
CC
G3
NR
KC
GB
NB
NR
TH
KC
TH
CC
KR
TH
AW
WL
NB
TB
WL
GS
WL
TH
CC
AE
WL
WL
G3
NB
KR
GS
CC
NR
GS
GB
CI
TH
LP
G3
CC
NR
HS
GS
G3
CC
NR
TB
NR
KC
TB
KC
OS
OS
NR
TB
LP
GB
GS
KC
KR
TB
GB
GB
G3
NB
CC
TH
GB
G3
G3
NB
GH
CC
KC
G3
G3
KR
TH
GS
TB
MW
GB
NR
GB
HS
AE
GS
NR
K8
14
TH
VY
CC
TH
KC
OS
GS
OS
GB
KR
NR
CC
GH
GB
G3
TH
WL
TB
WL
GB
AE
NB
CC
KC
KR
KC
CC
KC
AE
GH
CI
NR
TH
OS
NR
AW
CC
GB
G3
G3
GS
TH
KR
NB
WL
MM
GS
NR
KC
G3
GS
WL
NB
TB
KL
KC
TB
GS
NR
AW
TH
KC
CC
WL
JA
TH
GH
G3
NR
TH
KC
IV
NB
TH
AE
CC
KC
GS
KC
WL
CC
NR
AE
GS
TH
NB
KC
AW
NB
NR
TB
WL
NB
GG
GB
TH
CC
KC
GB
KC
KC
NR
NB
HS
GS
GS
KC
TH
NB
GS
NB
TH
CI
GS
KC
GS
KR
CC
G3
CC
GB
GS
NB
WL
GB
WL
GS
NB
TB
NB
TB
KR
WL
KR
NB
KK
AE
KR
AE
TB
WL
GH
KR
KC
AW
NB
GS
AE
AW
NB
NR
WL
CC
NB
IV
TB
NR
NR
IV
KC
GB
TH
GS
KR
GH
OS
CC
KC
WL
AE
GB
TH
G3
TB
TH
CC
GB
GH
NB
KK
TB
GS
NR
VE
VE
KC
NR
GS
IV
NB
LP
GS
TB
NB
TH
NB
TH
G3
WL
KC
GS
KC
TB
HS
OS
TH
WL
NB
HS
GB
HS
FE
GS
CC
KK
HS
GS
KR
GB
GS
TH
LP
GS
GB
OS
LP
NR
TH
WL
GS
WL
NB
HS
KC
CI
NB
CC
GS
NR
AE
WL
OS
CC
KC
TB
TH
K9
OS
TB
CC
KR
TH
KR
KR
KC
HS
OS
GS
NR
G3
KC
OS
TH
WL
NR
HS
GB
GS
WL
CC
KR
AW
GB
GS
NR
NB
KC
GS
KC
IV
GS
NB
TH
NB
KC
CC
CC
NB
WL
GS
GS
IV
AE
G3
KC
GB
NB
NR
TH
NR
NR
K6
HS
GB
NR
AE
KC
TH
NB
NB
NB
TH
FE
KC
CC
TB
WL
TH
TB
KR
TH
TH
G3
TH
TB
GB
CC
WL
NR
TB