Hi there All
Can anyone help me ? I am trying to find a way of...... Example

1,2,3,4,5,6 I want to write a formular that will list in the spreadsheet
the combinations of say 3s. The answer to this would be:
123 - 124 - 125 - 126 - 134 - 135 - 136 - 145 - 146 - 156
234 - 235 - 236 -245 - 246 - 256 - 345 -346 - 356 - 456

I have tried using COMBIN but can only seem to get a total ie COMBIN (6,3)
ans 20
Can excel list these combinations ? I'm not sure

Thanks in advance
BOB