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.
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
Thanks Greg. Works great
Try this...
Data Range
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.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi again,
Many thanks for your feedback and also for the Reputation increase
Glad I was able to help.
Best regards,
Greg M
Thanks Biff. This works great as well.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks