What formula to use.

[bloubul]

Hi All

What excel formula can I use to split a pick 3 draw into the following:
ab ac ba bc ca cb, I know that all draws cannot split into 6 combo's.

BlouBul

 

[Frank]

Its a lot easier if you have the 3 digits in separate columns such as col A, col B, Col C

so if you had cell A1 value 7, cell B1 value 2, cell c1 value 9

in cell E1 formula is =A1&B1
in cell F1 formula is =A1&C1
in cell G1 formula is =B1&A1
in cell H1 formula is =B1&C1
in cell I1 formula is =C1&A1
in cell J1 formula is =C1&B1

should give you :

72

79

27

29

97

92

Note it still works with zero values e.g 068 becomes

06

08

60

68

80

86

If you have your 3 digits in a single cell (or column) then considerably more manipulation is needed to split them up, and the cells would need to be formatted to display any leading zeroes..

 

[bloubul]

Frank

Thank you SIR I tip my hat to you.

BlouBuk