#### 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 |

1 | 00:00:00 | 1 | 1 |

2 | 00:15:00 | 2 | 2 |

3 | 00:30:00 | 3 | 3 |

<tbody>

</tbody>

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

Appreciate any help

Thank you

John