Excel combinations we can create for segment variables A B C

[Madhuri_G]

Hello Wonderful Excel Ninjas,

Would anyone be able to try to find out Excel combinations for this scenario, attached

looking for combination of CELL A with cell B, C, D

FOR Eg looking like
R1M1F1
R2M2F2
R3M3F3
R1M3F3
R2M1F1
R3M2F2
R1M2F2
R2M3F3
R3M1F1


Something like that... can you please let me know the formula or combinations we can do?

 

[Peter Bartholomew]

Is M1R1F1 a valid alternative to R1M1F1 or are they the same?

 

[Madhuri_G]

It can be a valid alternative or else we can do like keeping R's constant and fine tune combinations of M and F's.. Is that possible?

 

[Peter Bartholomew]

Madhuri
I do not for a moment suggest this is the solution for you but it is a possible solution and might help to define your requirement more closely. For a start, I have used BASE and CONCAT which are only available in relatively recent versions of Excel.