Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The objectivon is to list card numbers (i.e. 0006, 0011, 1297, 2305, etc.) on
a sheet (Sheet 2) in the same row as the package designation (i.e. BC01X, BC02A, BC03B, etc.) for that group. The data comes from a sheet (Sheet 1) where the card numbers column is sorted, but the package designation is not. The number of cards varies from package to package. The listing of card numbers on the packages sheet (2) must be in consecutive cells within the row with no blanks in between. Example: BC01X 0002 0009 0022 0096 0588 1122 BC02A 0006 0016 0038 1445 BC03B 1233 1235 5996 6093 6095 7022 7145 8432 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CODE 2 SELECT SHEETS LISTED IN A RANGE | Excel Discussion (Misc queries) | |||
How to select a listed item? | Excel Worksheet Functions | |||
How to select a listed item? | Excel Discussion (Misc queries) | |||
sorted but did not select all columns | Excel Discussion (Misc queries) | |||
work-around for "vlookup: with unsorted data | Excel Worksheet Functions |