Excel Formula needed please

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 :cool:
 

Frank

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 :cool:

Bloubul,

I have read this several times and it still doesn't make any sense at all. I presume others have done the same and gone away scratching their heads. Are you using secret codes you are not telling us about ?

What is A?
What is L ? H, I, J , K etc??????

Please explain what you mean by "What formula can I use in excel to transfer the numbers in column A1:A15 according the letters in columns B1-D15."

example:- transfer number 19 ( where?) according to ABM ????

:confused::confused::confused:
 

Sidebar

Top