Batch excel

ABC
1 class 1 class 372808200813001
2 class 2 class 3 class 372808200813002
3 classes 372808200813003
4 classes 4 classes 372808200813004
5 classes 5 classes 372808200813005
6 classes 6 classes 372808200813006
7 Class 7 Class 372808200813007
8 classes 372808200813008
9 Class 8 Class 9 Class 372808200813009
10 classes in 10 classes 372808200813010
11 classes in 11 classes 372808200813011
12 classes in 12 classes 372808200813012
13 classes, 13 classes 372808200813013
14 classes in 14 classes 372808200813014
15 classes in 15 classes 372808200813015
16 classes, 16 classes 372808200813016
17 classes, 17 classes 372808200813017
18 classes in 18 classes 372808200813018
19 classes 372808200813019
20 classes in 19 classes, 20 classes 372808200813020
21 classes in 21 classes 372808200813021
22 classes of 22 classes 372808200813022
1 class
2 class
3 classes
4 classes
5 classes
6 classes
7 classes
8 classes
9 classes
10 classes
11 Class 3
data ABC, A out hundreds of thousands, trying to A Out into the corresponding number of B out

C out whether or not the right number?
If so, the direct use of A1 = C1 , The drop-down formula can be copied to your A / B is not the same as the data out of it? (Italian title point of view, there are A, B, C 3, A \ B, like, C as a number)