#### abberyfarm

##### Well-known Member

- Joined
- Aug 14, 2011

- Messages
- 733

Would anybody know how I could create all possible combinations of 3 variables in Columns A,B and C.

I have the following

1. time values in 15minute blocks i.e. 00:15:00, 00:30:00....23:45:00

2. A set of numbers from 1 to 76.

3. A set of numbers list of 1 to 60.

So it the first 3 combinations would look something like this

**Sheet1**

* | A | B | C |

<tbody>

[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]00:00:00[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]00:15:00[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]00:30:00[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]3[/TD]

</tbody>

**Excel tables to the web >>**Excel Jeanie HTML 4

Appreciate any help

Thank you

John