Drag formula down and copy results from table x number of times

[LittleFry]

Column B contains unique values which I need to copy down column A in groups of 17 (I only did groups of 4 for display purposes).

In the end, the real data has over 750 unique values in column B so when multiplied by the groupings of 17 would make over 13000 rows for column A.

Can this be done with a formula?

Please Login or Register  to view this content.

[Greg M]

Hi there,

Take a look at the attached workbook and see if it does what you need.

The values to be copied are contained in a (highlighted) Named Range - the extent of this range should be increased to suit your own requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[LittleFry]

Thanks Greg. Works great

[Tony Valko]

Try this...

Data Range

	A	B
1	11aa	11aa
2	11aa	11ac
3	11aa	13ab
4	11aa	13ae
5	11ac
6	11ac
7	11ac
8	11ac
9	13ab
10	13ab
11	13ab
12	13ab
13	13ae
14	13ae
15	13ae
16	13ae
17	------	------

This formula entered in A1:

=IFERROR(INDEX(B$1:B$4,CEILING(ROWS(A$1:A1)/4,1)),"")

Replace the highlighted 4 with 17.

Copy down until you get blanks.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase

Glad I was able to help.

Best regards,

Greg M

[LittleFry]

Thanks Biff. This works great as well.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.