Find all combinations within a range that sum to a specific value

[csh8428]

I have 5 columns. Each Column has a pre-defined range. I'm trying to figure out all the combinations of summing the 5 columns while staying within the ranges that equal a specific value(164 in this case). 

	Column 1	Column 2	Column 3	Column 4	Column 5
Range	0-10	10-20	25-35	40-50	50-55

One constraint is that a number can't be duplicated in any of the columns along that row. For example using the ranges in the table, if Column 1 value = 10, then Column 2(or any other column) can't also be 10 for that row. I'm guessing this could be done using R, but I've never coded anything in R before.

Thanks for any help!

-Craig

[PhilipMannering]

👋 Craig.

I think this does the job,

[Qiu]

@csh8428 
Not as elegant as the one from @PhilipMannering .and I made this to be static.
With a bit more effort, we can make a dynamic though.

[PhilipMannering]

@Qiu Your way runs a lot quicker by virtue of it being Alteryx only.

Reassuring that we got the same number of records!

[Qiu]

@PhilipMannering 
Thank you for the confirmation. Glad to know that.