bloubul
Member
I have the following in the columns as indicated below.
A1-A15 B1-B15 C1-C15 D1-D15
9 A B C
34 A B D
7 A B E
28 A B F
42 A B G
18 A B H
40 A B I
43 A B J
44 A B K
17 A B L
19 A B M
20 A B N
6 A B O
13 A C D
25 A C E
A1-A15 is nrs.
What formula can I use in excel to transfer the numbers in column A1:A15 according the letters in columns B1-D15.
Any one please.
BlouBul
A1-A15 B1-B15 C1-C15 D1-D15
9 A B C
34 A B D
7 A B E
28 A B F
42 A B G
18 A B H
40 A B I
43 A B J
44 A B K
17 A B L
19 A B M
20 A B N
6 A B O
13 A C D
25 A C E
A1-A15 is nrs.
What formula can I use in excel to transfer the numbers in column A1:A15 according the letters in columns B1-D15.
Any one please.
BlouBul