Multiple conditions formula

  • Thread starter Thread starter dkenebre
  • Start date Start date
D

dkenebre

If I have the following sample scenarios below how do I build a formula
structure to automatically give me these results base upon the initial
inputted Value:

sample #1
Value =372
H=193
T=0248
C=675
Then value 372 = HCT or HTC

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

and so on........
 
Assume value is in A2

=Mid("THTHTCCCTH",Left(A2,1)-1,1)&Mid("THTHTCCCTH",Mid(A2,2,1)-1,1)&Mid("THT
HTCCCTH",Right(A2,1-1,1)

or to get

HCT or HTC

=MID("THTHTCCCTH",LEFT(A2,1)-1,1)&MID("THTHTCCCTH",MID(A2,2,1)-1,1)&MID("THT
HTCCCTH",RIGHT(A2,1)-1,1) & " OR " &MID("THTHTCCCTH",LEFT(A2,1)-1,1)&
MID("THTHTCCCTH",RIGHT(A2,1)-1,1)&MID("THTHTCCCTH",MID(A2,2,1)-1,1)
 
Back
Top