Row/ Column Auto Produce.

[elbobbo]

Hey I am fairly new to using Excel.

Apologies if this should be in a different section.

I want to configure a part of the document so that it formulates and present certain data that corresponds to data in a single cell.

Ok ill explain below.

I have two types of tables (like the furniture). A Small (0.8m width) and Large (1.6m width). Each table requires a 0.8m walkway between them.
The first figure will be one table then two then three and so on, with all configurations. With the total width being calculated.
E.g

1. S = Width 0.8m
2. L = Width 1.6m
3. S/W/S = Width 2.4m
4. S/W/L = Width 3.2m
5. L/W/L = Width 4m
6. S/W/S/W/S = Width 4m
7. S/W/S/W/L = Width 4.8m
8. S/W/L/W/L = Width 5.6m
9. L/W/L/W/L = Width 6.4m
10.S/W/S/W/S/W/S = Width 5.6m
11.S/W/S/W/S/W/L = Width 6.4m ..................And So On.

I need for in the single cell has the number 5. The following combinations will be generated.

1. S = Width 0.8m
2. L = Width 1.6m
3. S/W/S = Width 2.4m
4. S/W/L = Width 3.2m
5. L/W/L = Width 4m
6. S/W/S/W/S = Width 4m
7. S/W/S/W/L = Width 4.8m

Being all the possible combinations of the tables, but does not go over 5m.

What type of formula would i need to get this?
Cheers

[Bernie Deitrick]

The attached file show how you should enter your data, and what formula to use. The formula is entered using Ctrl-Shift-Enter instead of just Enter because it is an array formula.