Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorted one list based on another one
I have two lists I need to match up... one is a long set of numbers (all
distinct numbers, none repeated), and another set that has all of the same numbers-- but multiples of each of the number, along with a few columns of data corresponding to different sets of sample data. What I need to do is expand the first list so that it matches the numbers on the second list... basically copying each number as many times as it is repeated in the second list. Is there any way to do this more efficiently than manually going through and inserting lines, and then copying? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping an Excel list sorted | Excel Discussion (Misc queries) | |||
Sorted list | Excel Discussion (Misc queries) | |||
how to count records in a sorted list | Excel Worksheet Functions | |||
Need sorted validation list | Excel Worksheet Functions | |||
An alphabetically sorted list of findings... | Excel Discussion (Misc queries) |