A
Alaric
In excel 2000.
I would like to create a formula that would automatically populate the rows
on a worksheet according to a variable number.
Eg: Product A, Product B, and Product C with the variable number 3.
I would like to automatically populate the first column with three rows
containing "Product A", then the next three rows with "Product B", and a
further three rows with "Product C".
If the variable number were to change to 4 - then I want the same kind of
automated population except the column would have 4 rows of "Product A",
"Product B" and "Product C".
I've tried a combination of COUNTA and VLOOKUP functions, but I keep
creating a circular reference.
Is there a function for the "CTRL+ENTER" command?
I would like to create a formula that would automatically populate the rows
on a worksheet according to a variable number.
Eg: Product A, Product B, and Product C with the variable number 3.
I would like to automatically populate the first column with three rows
containing "Product A", then the next three rows with "Product B", and a
further three rows with "Product C".
If the variable number were to change to 4 - then I want the same kind of
automated population except the column would have 4 rows of "Product A",
"Product B" and "Product C".
I've tried a combination of COUNTA and VLOOKUP functions, but I keep
creating a circular reference.
Is there a function for the "CTRL+ENTER" command?