L
lehigh46
Hi All
The following alpha/numeric codes are "work type codes". 84 in all.
These codes reside in cells J1 through CO1
A B C C1 C2 C5 C6 C4 D
E F F1 F2 F3 F4 G G1 G2
G3
G4 W B1 C3 H H1 H2 J J1
J2 K K1 K2 L M M1 M2 M3
N
N1 O O1 O2 O3 P P1 P2 P3
P4 P5 P6 P7 P8 Q Q1 R R1
S
S0 S1 S2 S3 S4 S5 S6 S7 S8
S9 T T1 T3 T4 T5 T6 T7 T8
T9
U U1 V V1 V2 X Z ZZ
Column B contains contractors names. (About 400)
Column D contains the codes listed below.
The following codes are associated with a specific contractor in
column D and reside in the same cell.
B, B1, C1, C3, H, H1, H2, K, K1, K2, M2
The example above showes 11 codes. A contractor may have only one code
or a contractor may have all 84 codes. All codes are followed by a
comma and a space with the exception of the last code.
I want to write a formula at the intersections of the codes in row 1
and column D that will yield a charactor or a number if any of the 84
codes at the top match any of the codes contained in the cell for each
contractor.
I hope I explained this correctly
Thanks for any help you can give me.
Tom Snyder
x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD
The following alpha/numeric codes are "work type codes". 84 in all.
These codes reside in cells J1 through CO1
A B C C1 C2 C5 C6 C4 D
E F F1 F2 F3 F4 G G1 G2
G3
G4 W B1 C3 H H1 H2 J J1
J2 K K1 K2 L M M1 M2 M3
N
N1 O O1 O2 O3 P P1 P2 P3
P4 P5 P6 P7 P8 Q Q1 R R1
S
S0 S1 S2 S3 S4 S5 S6 S7 S8
S9 T T1 T3 T4 T5 T6 T7 T8
T9
U U1 V V1 V2 X Z ZZ
Column B contains contractors names. (About 400)
Column D contains the codes listed below.
The following codes are associated with a specific contractor in
column D and reside in the same cell.
B, B1, C1, C3, H, H1, H2, K, K1, K2, M2
The example above showes 11 codes. A contractor may have only one code
or a contractor may have all 84 codes. All codes are followed by a
comma and a space with the exception of the last code.
I want to write a formula at the intersections of the codes in row 1
and column D that will yield a charactor or a number if any of the 84
codes at the top match any of the codes contained in the cell for each
contractor.
I hope I explained this correctly
Thanks for any help you can give me.
Tom Snyder
x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD