To find all combinations of numbers from list of numbers that adds upto a specified number

hiii..

Suppose I have 1 to 10 written in A1 to A10 (there can be any random numbers & of random size)

I want to find all combinations of numbers that adds upto say 7 (which I will specify)

so I want all combinations from 1 to 10 that adds upto 7 (each combination in different column)

The combinations here would be i guess 1,6 2,5 3,4 1,2,4.

No repetitions / duplicates allowed..also 1,6 same as 6,1 so want it once only..

attached image of my query for more clarity..

Thanks.

Hii Mick..that code works wonders..thank you so much for the efforts to make the code..appreciable!!

a small issue...

When I write 9 in B1 & run the code column I gives combination of 4 5 5 i.e. the extra 5 in row 3..other everything is perfect..

same issue with 10..Column I gives 4 6 & 5...

I know it's a very small bug for you to be rectiifed..

Thanks a lot once again..

I can't duplicate that , but have added a line to clear cells to right of column "F" and down before new results are added.

Please Login or Register  to view this content.

Regards Mick

Awesome..Thank you so much mike...

You're welcome

Perfect!! Thanks a lot Yasser!!