LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to select sorted data listed under an unsorted grouping?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CODE 2 SELECT SHEETS LISTED IN A RANGE Faraz A. Qureshi Excel Discussion (Misc queries) 1 July 30th 09 07:31 AM
How to select a listed item? Eric Excel Worksheet Functions 3 August 11th 07 02:20 AM
How to select a listed item? Eric Excel Discussion (Misc queries) 1 August 10th 07 05:26 PM
sorted but did not select all columns confused Excel Discussion (Misc queries) 2 February 8th 07 10:14 PM
work-around for "vlookup: with unsorted data mark kubicki Excel Worksheet Functions 1 August 2nd 05 08:49 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"