Forum Discussion
Solved
How to make a function to generate genetic code table?
I would like to make a function which generates the green columns with this character sort. For example, A2 cell is RB and B1 cell is rB the result will be: RrBB (first concatenate the two cell's st...
@ChocolateTibi BTW, if the other person's prior solution works for you great, but my excel doesn't like SORT or SEQUENCE. Also, just for fun I thought of another way. This way is a little more 'generic' in that it doesn't explicitly require "R" first and "B" second but still requires first and second char different:
=CHAR(MIN(CODE($A7),CODE(B$6)))&CHAR(MAX(CODE($A7),CODE(B$6)))&CHAR(MIN(CODE(RIGHT($A7,1)),CODE(RIGHT(B$6,1))))&CHAR(MAX(CODE(RIGHT($A7,1)),CODE(RIGHT(B$6,1))))
if you want to combine things like "RR" & "rr" to get "RRrr" the above would have to get expanded to use LARGE and include all 4 characters in each case.
mtarler It's working, and easy to understand. Thank for your contribution! I learned a lot with your solutions.
ChocolateTibiYou're very welcome, I'm glad I could help, and most importantly I'm glad to hear you learned more.