C
Cosmo
I'm looking for a way to automatically assign an 'index value' to cells in
column "index". Starting with row one, I want to assign "A" based on the
contents
of the "item#" and "country" cells in the same row. And then, I want "A"
assigned to
every row containing the same values in those columns. And then, I want the
next different value (in this case, the 2nd row) to be assigned "B"...again
with every other row containing the same values in the "Item#" and "county"
columns to be assigned the index value of "B"....and so on and so on. Is
there a function that can be combined with a logic statement to automatically
assign values to all cells in the "index" column?
Index Order Item#
country
1 8502 1 4215.00 4,215.00 TW
2 8943 1 1802.00 1,802.00 TW
3 2251 1 188.00 188.00 CN
4 2251 1 935.00 935.00 CN
5 2251 1 450.00 450.00 CN
6 2251 1 25.00 25.00 CN
7 2251 2 701.38 1,402.76 CN
8 2251 1 179.57 179.57 CN
9 2251 2 50.00 100.00 CN
10 2251 14 100.00 1,400.00 CN
11 2251 1 1800.00 1,800.00 TW
12 2251 1 100.00 100.00 TW
13 2251 1 25.00 25.00 TW
14 2251 1 56.45 56.45 TW
15 2251 1 435.00 435.00 TW
16 2251 1 235.20 235.20 TW
17 2251 1 538.00 538.00 TW
18 2251 3 174.45 523.35 TW
19 2251 1 1923.00 1,923.00 TW
20 2251 1 843.00 843.00 TW
21 2251 1 400.00 400.00 CN
22 2251 1 400.00 400.00 CN
23 2251 1 3434.00 3,434.00 CN
24 2251 1 942.89 942.89 CN
25 8925 1 225.00 225.00 CN
26 7234 2 1307.00 2,614.00 JP
27 8925 1 1395.00 1,395.00 TW
28 2251 1 632.70 632.70 TW
29 6102 1 8500.00 8,500.00 TW
30 7616 1 1822.00 1,822.00 TW
column "index". Starting with row one, I want to assign "A" based on the
contents
of the "item#" and "country" cells in the same row. And then, I want "A"
assigned to
every row containing the same values in those columns. And then, I want the
next different value (in this case, the 2nd row) to be assigned "B"...again
with every other row containing the same values in the "Item#" and "county"
columns to be assigned the index value of "B"....and so on and so on. Is
there a function that can be combined with a logic statement to automatically
assign values to all cells in the "index" column?
Index Order Item#
country
1 8502 1 4215.00 4,215.00 TW
2 8943 1 1802.00 1,802.00 TW
3 2251 1 188.00 188.00 CN
4 2251 1 935.00 935.00 CN
5 2251 1 450.00 450.00 CN
6 2251 1 25.00 25.00 CN
7 2251 2 701.38 1,402.76 CN
8 2251 1 179.57 179.57 CN
9 2251 2 50.00 100.00 CN
10 2251 14 100.00 1,400.00 CN
11 2251 1 1800.00 1,800.00 TW
12 2251 1 100.00 100.00 TW
13 2251 1 25.00 25.00 TW
14 2251 1 56.45 56.45 TW
15 2251 1 435.00 435.00 TW
16 2251 1 235.20 235.20 TW
17 2251 1 538.00 538.00 TW
18 2251 3 174.45 523.35 TW
19 2251 1 1923.00 1,923.00 TW
20 2251 1 843.00 843.00 TW
21 2251 1 400.00 400.00 CN
22 2251 1 400.00 400.00 CN
23 2251 1 3434.00 3,434.00 CN
24 2251 1 942.89 942.89 CN
25 8925 1 225.00 225.00 CN
26 7234 2 1307.00 2,614.00 JP
27 8925 1 1395.00 1,395.00 TW
28 2251 1 632.70 632.70 TW
29 6102 1 8500.00 8,500.00 TW
30 7616 1 1822.00 1,822.00 TW