Making tables based on spesific conditions with formulas

Hi

I need to create a table with three variables (H,U,B) in 9 columns. The table will therefore be 19683 (3^9) rows high and 9 columns wide
So i.e the first string can be H,H,H,H,H,H,H,H,H and the second U,H,H,H,H,H,H,H,H and so on....
Is there an easy way to do this?

Br Stian

Hi,

Would things like this help?

http://stackoverflow.com/questions/1...ion-of-a-range
http://www.mrexcel.com/forum/excel-q...binations.html

(I looked for "excel create table with all combinations" in google)

If not, I'm sure there are VBA experts here that will be able to help you ;]