| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a variable print list
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. -- Thanks for your suggestions. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a variable print list
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 -- Allllen "SRK" wrote: 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. -- Thanks for your suggestions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a variable for file names | Excel Discussion (Misc queries) | |||
| Creating a dynamic list based on a minimum common variable. | Excel Worksheet Functions | |||
| creating a variable | New Users to Excel | |||
| Creating cell references with variable values to use in Vlookup | Excel Discussion (Misc queries) | |||
| Variable print area | Excel Discussion (Misc queries) | |||
Linear Mode
