How do I Create This Multiple String Formula?

D

dkenebre

I would like to take the numbers in cell A1, B1 and C1 and
compare it to numbers in D1, column D is for H numbers
and then compare it to E1, column E is for T numbers
and then compare it to F1, column F is for C numbers

1. If the 3 cells have all 3 numbers in D1, then G1:I1=H,H,H
and J1=HHH, because of the order it occurred in.

2. If the 3 cells have one cell number in D1, and one in E1, and one in
F1, then G1:I1=H,T,C
and J1 could equal THC or TCH or CHT or CTH or HCT or HTC, depending on
the order it occurred in.

3. If the 3 cells have two cells have numbers in D1, and one in E1, and
none in F1, then G1:I1=H,H,T
and J1=THC, depending on the order it occurred in.

4. If the cells have one cells that has a number in D1, two in E1, and
none in F1, then G1:I1=HTT
and J1 could equal HTT, THT,TTH, depending on the order.

5. If there were one in D1, none in E1 and two in F1, then G1:I1=H,C,C
and J1 could be HCC, CHC, or CCH

6. If none in D1, two in E1, and one in F1, then G1:I1=T,T,C
and J1 could be TTC, TCT or CTT

7. If none in D1, all 3 in E1 and none in F1, then G1:I1=T,T,T
and J1 would be TTT.

8. If none in D1, 1 in E1, 2 in F1, then G1:I1=T,C,C
and J1 could be TCC, CTC, or CCT

9. IF none in D1 and none if E1 and all 3 in F1, then G1:I1=C,C,C
and J1 would be CCC

10. if 2 in D1, and none in E1 and 1 in F1, then G1:I1=H,H,C
and J1 could be HHC, HCH, CHH


sample #1
If Value =372
H=193
T=0248
C=675
Then value 372 = H,T,C and HCT

Sample#2
Value=203
H=193
T=0248
C=675
Then value 372 = H,T,T and HTT

Chart would look something like this:
using sample #1
,,,,,,,,,,,,H num,,,T num,,,C num
A1 B1 C1,,,,,D1,,,,,,E1,,,,,,F1,,,,G1,H1,I1,,,J1
3,,,7,,,2,,,,,193,,,,0248,,,675,,,,H,,,T,,,C,,,HCT

and so on........
So, I would need a formula for G1,H1,I1 and J1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top