Thank you very much it works.
Although ,I forgot to mention that I would like to see the other 6 numbers
not in the group of 6 as well for each combination.

"Rendar" wrote:

Hello,
I have a list of twelve distinct numbers and would like to somehow display
all distinct combinations of 6 on Excel. The COMBIN function just gives me
the total number of them (924). Is there a way to explicitly show them?