Spreadsheet: 741629d1627217971-formula-to-do-number-and-extract-values-sequential-numbering-and-extract-values_sample
Sheet: HERE

Serial # | Month Sales | Code |  | Month Sales | Outcome
1 | 34 | SSA |  | 34 | SSA
2 | 35 | TYA |  | 33 | SSA
3 | 31 | DER |  | 32 | SSA
4 | 33 | [NAME] |  | 31 | SSA
5 | 36 | DAN |  | 30 | SSA
6 | 31 | FER |  | 29 | SSA
7 | 34 | RIT |  | 28 | SSA
8 | 37 | REN |  | 27 | SSA
9 | 32 | MON |  | 26 | SSA
10 | 35 | NON |  | 25 | SSA
11 | 30 | NCE |  | 24 | SSA
12 | 33 | GVT |  | 23 | SSA
 |  |  |  | 22 | SSA
 |  |  |  | 21 | SSA
 |  |  |  | 20 | SSA
 |  |  |  | 19 | SSA
 |  |  |  | 18 | SSA
 |  |  |  | 17 | SSA
 |  |  |  | 16 | SSA
 |  |  |  | 15 | SSA
 |  |  |  | 14 | SSA
 |  |  |  | 13 | SSA
 |  |  |  | 12 | SSA
 |  |  |  | 11 | SSA
 |  |  |  | 10 | SSA
 |  |  |  | 9 | SSA
 |  |  |  | 8 | SSA
 |  |  |  | 7 | SSA
 |  |  |  | 6 | SSA
 |  |  |  | 5 | SSA
 |  |  |  | 4 | SSA
 |  |  |  | 3 | SSA
 |  |  |  | 2 | SSA
 |  |  |  | 1 | SSA
 |  |  |  | 35 | TYA
 |  |  |  | 34 | TYA
 |  |  |  | 33 | TYA
 |  |  |  | 32 | TYA
 |  |  |  | 31 | TYA
 |  |  |  | 30 | TYA
 |  |  |  | 29 | TYA
 |  |  |  | 28 | TYA
 |  |  |  | 27 | TYA
 |  |  |  | 26 | TYA
 |  |  |  | 25 | TYA
 |  |  |  | 24 | TYA
 |  |  |  | 23 | TYA
 |  |  |  | 22 | TYA
 |  |  |  | 21 | TYA
 |  |  |  | 20 | TYA
 |  |  |  | 19 | TYA
 |  |  |  | 18 | TYA
 |  |  |  | 17 | TYA
 |  |  |  | 16 | TYA
 |  |  |  | 15 | TYA
 |  |  |  | 14 | TYA
 |  |  |  | 13 | TYA
 |  |  |  | 12 | TYA
 |  |  |  | 11 | TYA
 |  |  |  | 10 | TYA
 |  |  |  | 9 | TYA
 |  |  |  | 8 | TYA
 |  |  |  | 7 | TYA
 |  |  |  | 6 | TYA
 |  |  |  | 5 | TYA
 |  |  |  | 4 | TYA
 |  |  |  | 3 | TYA
 |  |  |  | 2 | TYA
 |  |  |  | 1 | TYA
 |  |  |  | 31 | DER
 |  |  |  | 30 | DER
 |  |  |  | 29 | DER
 |  |  |  | 28 | DER
 |  |  |  | 27 | DER
 |  |  |  | 26 | DER
 |  |  |  | 25 | DER
 |  |  |  | 24 | DER
 |  |  |  | 23 | DER
 |  |  |  | 22 | DER
 |  |  |  | 21 | DER
 |  |  |  | 20 | DER
 |  |  |  | 19 | DER
 |  |  |  | 18 | DER
 |  |  |  | 17 | DER
 |  |  |  | 16 | DER
 |  |  |  | 15 | DER
 |  |  |  | 14 | DER
 |  |  |  | 13 | DER
 |  |  |  | 12 | DER
 |  |  |  | 11 | DER
 |  |  |  | 10 | DER
 |  |  |  | 9 | DER
 |  |  |  | 8 | DER
 |  |  |  | 7 | DER
 |  |  |  | 6 | DER
 |  |  |  | 5 | DER
 |  |  |  | 4 | DER
 |  |  |  | 3 | DER
 |  |  |  | 2 | DER
 |  |  |  | 1 | DER
 |  |  |  | 33 | [NAME]
 |  |  |  | 32 | [NAME]
 |  |  |  | 31 | [NAME]
 |  |  |  | 30 | [NAME]
 |  |  |  | 29 | [NAME]
 |  |  |  | 28 | [NAME]
 |  |  |  | 27 | [NAME]
 |  |  |  | 26 | [NAME]
 |  |  |  | 25 | [NAME]
 |  |  |  | 24 | [NAME]
 |  |  |  | 23 | [NAME]
 |  |  |  | 22 | [NAME]
 |  |  |  | 21 | [NAME]
 |  |  |  | 20 | [NAME]
 |  |  |  | 19 | [NAME]
 |  |  |  | 18 | [NAME]
 |  |  |  | 17 | [NAME]
 |  |  |  | 16 | [NAME]
 |  |  |  | 15 | [NAME]
 |  |  |  | 14 | [NAME]
 |  |  |  | 13 | [NAME]
 |  |  |  | 12 | [NAME]
 |  |  |  | 11 | [NAME]
 |  |  |  | 10 | [NAME]
 |  |  |  | 9 | [NAME]
 |  |  |  | 8 | [NAME]
 |  |  |  | 7 | [NAME]
 |  |  |  | 6 | [NAME]
 |  |  |  | 5 | [NAME]
 |  |  |  | 4 | [NAME]
 |  |  |  | 3 | [NAME]
 |  |  |  | 2 | [NAME]
 |  |  |  | 1 | [NAME]
 |  |  |  | 36 | DAN
 |  |  |  | 35 | DAN
 |  |  |  | 34 | DAN
 |  |  |  | 33 | DAN
 |  |  |  | 32 | DAN
 |  |  |  | 31 | DAN
 |  |  |  | 30 | DAN
 |  |  |  | 29 | DAN
 |  |  |  | 28 | DAN
 |  |  |  | 27 | DAN
 |  |  |  | 26 | DAN
 |  |  |  | 25 | DAN
 |  |  |  | 24 | DAN
 |  |  |  | 23 | DAN
 |  |  |  | 22 | DAN
 |  |  |  | 21 | DAN
 |  |  |  | 20 | DAN
 |  |  |  | 19 | DAN
 |  |  |  | 18 | DAN
 |  |  |  | 17 | DAN
 |  |  |  | 16 | DAN
 |  |  |  | 15 | DAN
 |  |  |  | 14 | DAN
 |  |  |  | 13 | DAN
 |  |  |  | 12 | DAN
 |  |  |  | 11 | DAN
 |  |  |  | 10 | DAN
 |  |  |  | 9 | DAN
 |  |  |  | 8 | DAN
 |  |  |  | 7 | DAN
 |  |  |  | 6 | DAN
 |  |  |  | 5 | DAN
 |  |  |  | 4 | DAN
 |  |  |  | 3 | DAN
 |  |  |  | 2 | DAN
 |  |  |  | 1 | DAN
 |  |  |  | 31 | FER
 |  |  |  | 30 | FER
 |  |  |  | 29 | FER
 |  |  |  | 28 | FER
 |  |  |  | 27 | FER
 |  |  |  | 26 | FER
 |  |  |  | 25 | FER
 |  |  |  | 24 | FER
 |  |  |  | 23 | FER
 |  |  |  | 22 | FER
 |  |  |  | 21 | FER
 |  |  |  | 20 | FER
 |  |  |  | 19 | FER
 |  |  |  | 18 | FER
 |  |  |  | 17 | FER
 |  |  |  | 16 | FER
 |  |  |  | 15 | FER
 |  |  |  | 14 | FER
 |  |  |  | 13 | FER
 |  |  |  | 12 | FER
 |  |  |  | 11 | FER
 |  |  |  | 10 | FER
 |  |  |  | 9 | FER
 |  |  |  | 8 | FER
 |  |  |  | 7 | FER
 |  |  |  | 6 | FER
 |  |  |  | 5 | FER
 |  |  |  | 4 | FER
 |  |  |  | 3 | FER
 |  |  |  | 2 | FER
 |  |  |  | 1 | FER
 |  |  |  | 34 | RIT
 |  |  |  | 33 | RIT
 |  |  |  | 32 | RIT
 |  |  |  | 31 | RIT
 |  |  |  | 30 | RIT
 |  |  |  | 29 | RIT
 |  |  |  | 28 | RIT
 |  |  |  | 27 | RIT
 |  |  |  | 26 | RIT
 |  |  |  | 25 | RIT
 |  |  |  | 24 | RIT
 |  |  |  | 23 | RIT
 |  |  |  | 22 | RIT
 |  |  |  | 21 | RIT
 |  |  |  | 20 | RIT
 |  |  |  | 19 | RIT
 |  |  |  | 18 | RIT
 |  |  |  | 17 | RIT
 |  |  |  | 16 | RIT
 |  |  |  | 15 | RIT
 |  |  |  | 14 | RIT
 |  |  |  | 13 | RIT
 |  |  |  | 12 | RIT
 |  |  |  | 11 | RIT
 |  |  |  | 10 | RIT
 |  |  |  | 9 | RIT
 |  |  |  | 8 | RIT
 |  |  |  | 7 | RIT
 |  |  |  | 6 | RIT
 |  |  |  | 5 | RIT
 |  |  |  | 4 | RIT
 |  |  |  | 3 | RIT
 |  |  |  | 2 | RIT
 |  |  |  | 1 | RIT
 |  |  |  | 37 | REN
 |  |  |  | 36 | REN
 |  |  |  | 35 | REN
 |  |  |  | 34 | REN
 |  |  |  | 33 | REN
 |  |  |  | 32 | REN
 |  |  |  | 31 | REN
 |  |  |  | 30 | REN
 |  |  |  | 29 | REN
 |  |  |  | 28 | REN
 |  |  |  | 27 | REN
 |  |  |  | 26 | REN
 |  |  |  | 25 | REN
 |  |  |  | 24 | REN
 |  |  |  | 23 | REN
 |  |  |  | 22 | REN
 |  |  |  | 21 | REN
 |  |  |  | 20 | REN
 |  |  |  | 19 | REN
 |  |  |  | 18 | REN
 |  |  |  | 17 | REN
 |  |  |  | 16 | REN
 |  |  |  | 15 | REN
 |  |  |  | 14 | REN
 |  |  |  | 13 | REN
 |  |  |  | 12 | REN
 |  |  |  | 11 | REN
 |  |  |  | 10 | REN
 |  |  |  | 9 | REN
 |  |  |  | 8 | REN
 |  |  |  | 7 | REN
 |  |  |  | 6 | REN
 |  |  |  | 5 | REN
 |  |  |  | 4 | REN
 |  |  |  | 3 | REN
 |  |  |  | 2 | REN
 |  |  |  | 1 | REN
 |  |  |  | 32 | MON
 |  |  |  | 31 | MON
 |  |  |  | 30 | MON
 |  |  |  | 29 | MON
 |  |  |  | 28 | MON
 |  |  |  | 27 | MON
 |  |  |  | 26 | MON
 |  |  |  | 25 | MON
 |  |  |  | 24 | MON
 |  |  |  | 23 | MON
 |  |  |  | 22 | MON
 |  |  |  | 21 | MON
 |  |  |  | 20 | MON
 |  |  |  | 19 | MON
 |  |  |  | 18 | MON
 |  |  |  | 17 | MON
 |  |  |  | 16 | MON
 |  |  |  | 15 | MON
 |  |  |  | 14 | MON
 |  |  |  | 13 | MON
 |  |  |  | 12 | MON
 |  |  |  | 11 | MON
 |  |  |  | 10 | MON
 |  |  |  | 9 | MON
 |  |  |  | 8 | MON
 |  |  |  | 7 | MON
 |  |  |  | 6 | MON
 |  |  |  | 5 | MON
 |  |  |  | 4 | MON
 |  |  |  | 3 | MON
 |  |  |  | 2 | MON
 |  |  |  | 1 | MON
 |  |  |  | 35 | NON
 |  |  |  | 34 | NON
 |  |  |  | 33 | NON
 |  |  |  | 32 | NON
 |  |  |  | 31 | NON
 |  |  |  | 30 | NON
 |  |  |  | 29 | NON
 |  |  |  | 28 | NON
 |  |  |  | 27 | NON
 |  |  |  | 26 | NON
 |  |  |  | 25 | NON
 |  |  |  | 24 | NON
 |  |  |  | 23 | NON
 |  |  |  | 22 | NON
 |  |  |  | 21 | NON
 |  |  |  | 20 | NON
 |  |  |  | 19 | NON
 |  |  |  | 18 | NON
 |  |  |  | 17 | NON
 |  |  |  | 16 | NON
 |  |  |  | 15 | NON
 |  |  |  | 14 | NON
 |  |  |  | 13 | NON
 |  |  |  | 12 | NON
 |  |  |  | 11 | NON
 |  |  |  | 10 | NON
 |  |  |  | 9 | NON
 |  |  |  | 8 | NON
 |  |  |  | 7 | NON
 |  |  |  | 6 | NON
 |  |  |  | 5 | NON
 |  |  |  | 4 | NON
 |  |  |  | 3 | NON
 |  |  |  | 2 | NON
 |  |  |  | 1 | NON
 |  |  |  | 30 | NCE
 |  |  |  | 29 | NCE
 |  |  |  | 28 | NCE
 |  |  |  | 27 | NCE
 |  |  |  | 26 | NCE
 |  |  |  | 25 | NCE
 |  |  |  | 24 | NCE
 |  |  |  | 23 | NCE
 |  |  |  | 22 | NCE
 |  |  |  | 21 | NCE
 |  |  |  | 20 | NCE
 |  |  |  | 19 | NCE
 |  |  |  | 18 | NCE
 |  |  |  | 17 | NCE
 |  |  |  | 16 | NCE
 |  |  |  | 15 | NCE
 |  |  |  | 14 | NCE
 |  |  |  | 13 | NCE
 |  |  |  | 12 | NCE
 |  |  |  | 11 | NCE
 |  |  |  | 10 | NCE
 |  |  |  | 9 | NCE
 |  |  |  | 8 | NCE
 |  |  |  | 7 | NCE
 |  |  |  | 6 | NCE
 |  |  |  | 5 | NCE
 |  |  |  | 4 | NCE
 |  |  |  | 3 | NCE
 |  |  |  | 2 | NCE
 |  |  |  | 1 | NCE
 |  |  |  | 33 | GVT
 |  |  |  | 32 | GVT
 |  |  |  | 31 | GVT
 |  |  |  | 30 | GVT
 |  |  |  | 29 | GVT
 |  |  |  | 28 | GVT
 |  |  |  | 27 | GVT
 |  |  |  | 26 | GVT
 |  |  |  | 25 | GVT
 |  |  |  | 24 | GVT
 |  |  |  | 23 | GVT
 |  |  |  | 22 | GVT
 |  |  |  | 21 | GVT
 |  |  |  | 20 | GVT
 |  |  |  | 19 | GVT
 |  |  |  | 18 | GVT
 |  |  |  | 17 | GVT
 |  |  |  | 16 | GVT
 |  |  |  | 15 | GVT
 |  |  |  | 14 | GVT
 |  |  |  | 13 | GVT
 |  |  |  | 12 | GVT
 |  |  |  | 11 | GVT
 |  |  |  | 10 | GVT
 |  |  |  | 9 | GVT
 |  |  |  | 8 | GVT
 |  |  |  | 7 | GVT
 |  |  |  | 6 | GVT
 |  |  |  | 5 | GVT
 |  |  |  | 4 | GVT
 |  |  |  | 3 | GVT
 |  |  |  | 2 | GVT
 |  |  |  | 1 | GVT