Creating a variable print list

S

SRK

I have a list of 40 apartment names and want to print each name on 200 to 300
individual labels. My variable print software requires these in a continuous
list in one column: i.e. Name A, 300 times; Name B 200 times; Name C 250
times and so on. Is there an easier way than copying and pasting 40 names
into a column. I'm looking for a formula to do this.
 
A

Allllen

formula is cell D1 is
=VLOOKUP(row(),A:C,3,1)
for the first 250 rows it gives nameone, then it gives nametwo, namethree
etc as you extend it down

Col A B C D
1 F-row T-row Name nameone
2 0 250 nameone nameone
3 251 351 nametwo nameone
4 501 600 namethree nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top