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)
 
Hopefully the previous reply explains my goal better.
Please help
Thank you.
 
You must log in or register to reply here.

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

Similar Threads

Scrabble Value calculation for Welsh words 0
Count based on multiple conditions 1
dynamic cell references in formulas 2
***Conditional Formatting Multiple Cells*** 1
How do I configure this formula? 5
Count Number Of Times Values Appears Consecutively, Return Longest 5
Require formula to search across multiple worksheets 2
Ranking values in multiple subsets using one single formula 1

Back
Top