Spreadsheet: 882051d1730311084-formula-for-letters-and-reverse-order-sorting-system-test-edit
Sheet: Hyllelokasjoner claude

LOKASJON | REOL | FAG | HYLLE | LOKASJON-NY | REOL-NY | FAG-NY | HYLLE-NY
01-01-01 | 01 | 01 | 01 |  | AA | 01 | H | 1 | Count how many of the same number in column G, for number 1 = 8 | Letter 8 in the alphabet is H, so that is the first letter of the series within column G number 1
01-01-02 | 01 | 01 | 02 |  | AA | 01 | G | 2 | It should then fill out the letters from 8(H) to 1(A)
01-01-03 | 01 | 01 | 03 |  | AA | 01 | F | 3
01-01-04 | 01 | 01 | 04 |  | AA | 01 | E | 4
01-01-05 | 01 | 01 | 05 |  | AA | 01 | D | 5
01-01-06 | 01 | 01 | 06 |  | AA | 01 | C | 6
01-01-07 | 01 | 01 | 07 |  | AA | 01 | B | 7
01-01-08 | 01 | 01 | 08 |  | AA | 01 | A | 8
01-02-01 | 01 | 02 | 01 |  | AA | 02 | G | 1
01-02-02 | 01 | 02 | 02 |  | AA | 02 | F | 2
01-02-03 | 01 | 02 | 03 |  | AA | 02 | E | 3
01-02-04 | 01 | 02 | 04 |  | AA | 02 | D | 4
01-02-05 | 01 | 02 | 05 |  | AA | 02 | C | 5
01-02-06 | 01 | 02 | 06 |  | AA | 02 | B | 6
01-02-07 | 01 | 02 | 07 |  | AA | 02 | A | 7
01-03-01 | 01 | 03 | 01 |  | AA | 03
01-03-02 | 01 | 03 | 02 |  | AA | 03
01-03-03 | 01 | 03 | 03 |  | AA | 03
01-03-04 | 01 | 03 | 04 |  | AA | 03
01-03-05 | 01 | 03 | 05 |  | AA | 03
01-03-06 | 01 | 03 | 06 |  | AA | 03
01-03-07 | 01 | 03 | 07 |  | AA | 03
01-04-01 | 01 | 04 | 01 |  | AA | 04
01-04-02 | 01 | 04 | 02 |  | AA | 04
01-04-03 | 01 | 04 | 03 |  | AA | 04
01-04-04 | 01 | 04 | 04 |  | AA | 04
01-04-05 | 01 | 04 | 05 |  | AA | 04
01-04-06 | 01 | 04 | 06 |  | AA | 04
01-04-07 | 01 | 04 | 07 |  | AA | 04
01-05-01 | 01 | 05 | 01 |  | AA | 05
01-05-02 | 01 | 05 | 02 |  | AA | 05
01-05-03 | 01 | 05 | 03 |  | AA | 05
01-05-04 | 01 | 05 | 04 |  | AA | 05
01-05-05 | 01 | 05 | 05 |  | AA | 05
01-05-06 | 01 | 05 | 06 |  | AA | 05
01-05-07 | 01 | 05 | 07 |  | AA | 05
01-06-01 | 01 | 06 | 01 |  | AA | 06
01-06-02 | 01 | 06 | 02 |  | AA | 06
01-06-03 | 01 | 06 | 03 |  | AA | 06
01-06-04 | 01 | 06 | 04 |  | AA | 06
01-06-05 | 01 | 06 | 05 |  | AA | 06
01-06-06 | 01 | 06 | 06 |  | AA | 06
01-06-07 | 01 | 06 | 07 |  | AA | 06
01-06-08 | 01 | 06 | 08 |  | AA | 06
01-06-09 | 01 | 06 | 09 |  | AA | 06
01-06-10 | 01 | 06 | 10 |  | AA | 06
01-07-01 | 01 | 07 | 01 |  | AA | 07
01-07-02 | 01 | 07 | 02 |  | AA | 07
01-07-03 | 01 | 07 | 03 |  | AA | 07
01-07-04 | 01 | 07 | 04 |  | AA | 07
01-07-05 | 01 | 07 | 05 |  | AA | 07
01-07-06 | 01 | 07 | 06 |  | AA | 07
01-07-07 | 01 | 07 | 07 |  | AA | 07
01-08-01 | 01 | 08 | 01 |  | AA | 08
01-08-02 | 01 | 08 | 02 |  | AA | 08
01-08-03 | 01 | 08 | 03 |  | AA | 08
01-08-04 | 01 | 08 | 04 |  | AA | 08
01-08-05 | 01 | 08 | 05 |  | AA | 08
01-08-06 | 01 | 08 | 06 |  | AA | 08
01-08-07 | 01 | 08 | 07 |  | AA | 08
01-09-01 | 01 | 09 | 01 |  | AA | 09
01-09-02 | 01 | 09 | 02 |  | AA | 09
01-09-03 | 01 | 09 | 03 |  | AA | 09
01-09-04 | 01 | 09 | 04 |  | AA | 09
01-09-05 | 01 | 09 | 05 |  | AA | 09
01-09-06 | 01 | 09 | 06 |  | AA | 09
01-09-07 | 01 | 09 | 07 |  | AA | 09
02-01-01 | 02 | 01 | 01 |  | AB | 01
02-01-02 | 02 | 01 | 02 |  | AB | 01
02-01-03 | 02 | 01 | 03 |  | AB | 01
02-01-04 | 02 | 01 | 04 |  | AB | 01
02-01-05 | 02 | 01 | 05 |  | AB | 01
02-01-06 | 02 | 01 | 06 |  | AB | 01
02-01-07 | 02 | 01 | 07 |  | AB | 01
02-02-01 | 02 | 02 | 01 |  | AB | 02
02-02-02 | 02 | 02 | 02 |  | AB | 02
02-02-03 | 02 | 02 | 03 |  | AB | 02
02-02-04 | 02 | 02 | 04 |  | AB | 02
02-02-05 | 02 | 02 | 05 |  | AB | 02
02-02-06 | 02 | 02 | 06 |  | AB | 02
02-02-07 | 02 | 02 | 07 |  | AB | 02
02-03-01 | 02 | 03 | 01 |  | AB | 03
02-03-02 | 02 | 03 | 02 |  | AB | 03
02-03-03 | 02 | 03 | 03 |  | AB | 03
02-03-04 | 02 | 03 | 04 |  | AB | 03
02-03-05 | 02 | 03 | 05 |  | AB | 03
02-03-06 | 02 | 03 | 06 |  | AB | 03
02-03-07 | 02 | 03 | 07 |  | AB | 03
02-04-01 | 02 | 04 | 01 |  | AB | 04
02-04-02 | 02 | 04 | 02 |  | AB | 04
02-04-03 | 02 | 04 | 03 |  | AB | 04
02-04-04 | 02 | 04 | 04 |  | AB | 04
02-04-05 | 02 | 04 | 05 |  | AB | 04
02-04-06 | 02 | 04 | 06 |  | AB | 04
02-04-07 | 02 | 04 | 07 |  | AB | 04
02-05-01 | 02 | 05 | 01 |  | AB | 05
02-05-02 | 02 | 05 | 02 |  | AB | 05
02-05-03 | 02 | 05 | 03 |  | AB | 05
02-05-04 | 02 | 05 | 04 |  | AB | 05
02-05-05 | 02 | 05 | 05 |  | AB | 05
02-05-06 | 02 | 05 | 06 |  | AB | 05
02-05-07 | 02 | 05 | 07 |  | AB | 05
02-06-01 | 02 | 06 | 01 |  | AB | 06
02-06-02 | 02 | 06 | 02 |  | AB | 06
02-06-03 | 02 | 06 | 03 |  | AB | 06
02-06-04 | 02 | 06 | 04 |  | AB | 06
02-06-05 | 02 | 06 | 05 |  | AB | 06
02-06-06 | 02 | 06 | 06 |  | AB | 06
02-06-07 | 02 | 06 | 07 |  | AB | 06
02-07-01 | 02 | 07 | 01 |  | AB | 07
02-07-02 | 02 | 07 | 02 |  | AB | 07
02-07-03 | 02 | 07 | 03 |  | AB | 07
02-07-04 | 02 | 07 | 04 |  | AB | 07
02-07-05 | 02 | 07 | 05 |  | AB | 07
02-07-06 | 02 | 07 | 06 |  | AB | 07
02-07-07 | 02 | 07 | 07 |  | AB | 07
03-01-01 | 03 | 01 | 01 |  | AC | 01
03-01-02 | 03 | 01 | 02 |  | AC | 01
03-01-03 | 03 | 01 | 03 |  | AC | 01
03-01-04 | 03 | 01 | 04 |  | AC | 01
03-01-05 | 03 | 01 | 05 |  | AC | 01
03-01-06 | 03 | 01 | 06 |  | AC | 01
03-01-07 | 03 | 01 | 07 |  | AC | 01
03-02-01 | 03 | 02 | 01 |  | AC | 02
03-02-02 | 03 | 02 | 02 |  | AC | 02
03-02-03 | 03 | 02 | 03 |  | AC | 02
03-02-04 | 03 | 02 | 04 |  | AC | 02
03-02-05 | 03 | 02 | 05 |  | AC | 02
03-02-06 | 03 | 02 | 06 |  | AC | 02
03-02-07 | 03 | 02 | 07 |  | AC | 02
03-03-01 | 03 | 03 | 01 |  | AC | 03
03-03-02 | 03 | 03 | 02 |  | AC | 03
03-03-03 | 03 | 03 | 03 |  | AC | 03
03-03-04 | 03 | 03 | 04 |  | AC | 03
03-03-05 | 03 | 03 | 05 |  | AC | 03
03-03-06 | 03 | 03 | 06 |  | AC | 03
03-03-07 | 03 | 03 | 07 |  | AC | 03
03-04-01 | 03 | 04 | 01 |  | AC | 04
03-04-02 | 03 | 04 | 02 |  | AC | 04
03-04-03 | 03 | 04 | 03 |  | AC | 04
03-04-04 | 03 | 04 | 04 |  | AC | 04
03-04-05 | 03 | 04 | 05 |  | AC | 04
03-04-06 | 03 | 04 | 06 |  | AC | 04
03-04-07 | 03 | 04 | 07 |  | AC | 04
03-05-01 | 03 | 05 | 01 |  | AC | 05
03-05-02 | 03 | 05 | 02 |  | AC | 05
03-05-03 | 03 | 05 | 03 |  | AC | 05
03-05-04 | 03 | 05 | 04 |  | AC | 05
03-05-05 | 03 | 05 | 05 |  | AC | 05
03-05-06 | 03 | 05 | 06 |  | AC | 05
03-05-07 | 03 | 05 | 07 |  | AC | 05
03-06-01 | 03 | 06 | 01 |  | AC | 06
03-06-02 | 03 | 06 | 02 |  | AC | 06
03-06-03 | 03 | 06 | 03 |  | AC | 06
03-06-04 | 03 | 06 | 04 |  | AC | 06
03-06-05 | 03 | 06 | 05 |  | AC | 06
03-06-06 | 03 | 06 | 06 |  | AC | 06
03-06-07 | 03 | 06 | 07 |  | AC | 06
03-07-01 | 03 | 07 | 01 |  | AC | 07
03-07-02 | 03 | 07 | 02 |  | AC | 07
03-07-03 | 03 | 07 | 03 |  | AC | 07
03-07-04 | 03 | 07 | 04 |  | AC | 07
03-07-05 | 03 | 07 | 05 |  | AC | 07
03-07-06 | 03 | 07 | 06 |  | AC | 07
03-07-07 | 03 | 07 | 07 |  | AC | 07