| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
populate duplicate data into a spreadsheet
Is there a way to populate duplicate inventory data into a spreadsheet
without typing it? For example... Qty 10 blouses @ 9.99 2 Sm, 4 Med, 4 Lg Is there a formula available so that the word 'Blouse' appears 10 times in Col A on lines 2-11 '9.99' appears 10 times in Col B lines 2-11 'Sm' appears in Col C lines 2-3 'Med' appears in Col C lines 4-7 'Lg' appears in Col C lines 8-11 I'd be grateful for any ideas and/or help. thanks. -- Toni Marie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export duplicate data into another spreadsheet | Excel Discussion (Misc queries) | |||
| Populate a spreadsheet from a data set | Excel Worksheet Functions | |||
| how to delete duplicate data from an excell spreadsheet | Excel Discussion (Misc queries) | |||
| Finding duplicate data between 2 spreadsheet workbooks? | Excel Discussion (Misc queries) | |||
| How do I highlight duplicate data on a spreadsheet? | Excel Worksheet Functions | |||
Threaded Mode
