Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
I have an excel Sheet with Column A containing the ANSZIC Code - Ranging from 0 to 9999
There are millions of records and i wanna a assign a code to classify these Numbers as Follows Ex
For Numbers FROM 0-529 it must be assigned A, and like wise
<colgroup><col><col></colgroup><tbody>
</tbody>Thank you in advance - It would be greatly helpful
There are millions of records and i wanna a assign a code to classify these Numbers as Follows Ex
For Numbers FROM 0-529 it must be assigned A, and like wise
0 – 529 | A |
600-1090 | B |
1111-1220 | C |
1311- 2599 | D |
2630-3299 | E |
3311-3800 | F |
3911-4320 | G |
4400-4530 | H |
4610-5029 | I |
5101-5309 | J |
5411-6020 | K |
6210-6420 | L |
6611-6639 | M |
6711-6720 | N |
6910-6999 | O |
7000-7320 | P |
7501-7720 | Q |
8010-8220 | R |
8401-8599 | S |
8601-8790 | T |
8910-9003 | U |
9111-9112 | V |
9113-9999 | W |
<colgroup><col><col></colgroup><tbody>
</tbody>