Ranges - list of all possible combinations

**stacylynn** · 03-04-2008, 11:38 AM

I am wondering if it is possible (if so, then how) to set up a worksheet where the user inputs a range for high and low and the spreadsheet adjusts accordingly. For example:

high:6 to 8
low: 3 to 5

Based on the high and low, I want to create a list of all possible combinations such as:

High Low
6 3
7 3
8 3
6 4
7 4
8 4
6 5
7 5
8 5

Let's suppose the user wants to change the range to say:

high: 8 to 11
low: 4 to 7

Is there a way for excel to adjust to the new range, change the size of the table, and automatically change to:

High Low
8 4
9 4
10 4
11 4
8 5
9 5
10 5
11 5
8 6
9 6
10 6
11 6
8 7
9 7
10 7
11 7

Any help would be appreciated! Thanks.

**Leith Ross** · 03-04-2008, 01:44 PM

Hello stacylynn,

Welcome to the Forum!

The attached workbook contains the macro shown below which shows the combinations. The entries are made into cells A3:D3 and a command button runs the macro to display the combinations.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**bandit6611** · 01-30-2015, 02:42 PM

So that works great with 2 sets of ranges, how about 5 or 6 sets? and how about letters?

Example:

length: 8-121
depth: 8-15
# of bowls: 0,1,2,3,4,
backsplash: nbs, 3bs, 4bs
color: sy, syss, cy, cyss, gy, gyss

So in that order meaning number 1 would be 880nbssy then 890nbssy and so on and so forth

**FDibbins** · 01-30-2015, 02:47 PM

bandit, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.