Repetition

Hi,

i have a problem and im not sure of the approach

i have uploaded a file.....basically i have an input of names and i want to repeat these as shown in the output..is this possible

i tried the rept function but can't get it right...any help appreciated.

thanks in advance

In C2 and copy down =INDEX(A:A, INT(ROW() - 2) / 4 + 2)

Please Login or Register  to view this content.

what he's done is take the row which you're looking at, ROW(), subtract 2 from it, so say, row 3, that would give a result of 1. Then 1/4 is 0.25, but the INT is the whole number integer, so it gives an answer of 0. Then there's that +2, so 0 + 2 is row 2, where the answer will be INDEXed from, in column A:A, being all of column A.

He's broken down every 4 number increase into a round number integer result in groups of 4, then used INDEX to return that whole number as a column. IE 2,3,4,5 all = 2, 6,7,8,9 all = 3

Edit:
Not trying to steal your thunder SHG, I didn't understand it either at a glance, so figured I'd go over it myself

If you're a happy camper, would you please mark the thread as Solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save