Sorting Groups

[Frank abel]

Hi
could you post some rows of your data (plain text - no
attachments please). The inportant thing is how do you
distinguish the groups from each other. e.g. is the first
column always the group name, etc.

 

[isa]

Each column contains 11 rows. The best way to probably distinguish each group
would be the collection #. Each piece in a group is in the same collection
and every group will have a different collection number.
Sorting Logic: Group 2's first row costs less than Group 1's first row so
Group 2 should be in front of Group 1.
Any help would be VERY appreciated!!! Thanks
~isa

CAT VNDR # VENDOR NAME COLLECTION # COLLECTION DESCRIPTION STYLE
NUMBER DESCRIPTION XX STYLE COST RETAIL
(ex. Group 1)
80 0939 SHERRILL UPHOLSTERY 0939195/02 SHERRIL UPH 195 PICASSO
TAUPE 0939195302 SOFA 90" PICASS XD CONTEMP 1099 1899
80 0939 SHERRILL UPHOLSTERY 0939195/02 SHERRIL UPH 195 PICASSO
TAUPE 0939179202 CHAIR 1/2 PICAS XD CONTEMP 699 1189
80 0939 SHERRILL UPHOLSTERY 0939195/02 SHERRIL UPH 195 PICASSO
TAUPE 0939179302 OTTOMAN PICASSO XD CONTEMP 275 449

(ex. group 2)

80 0506 INTERNATIONAL FURN CO 050660858 "PARAMOUNT" 050660858203 SOFA
89"25934/2 XD CONTEMP 650 1499
80 0506 INTERNATIONAL FURN CO 050660858 "PARAMOUNT" 050660858003 LOVESEAT
25934/ XD CONTEMP 630 1449
80 0506 INTERNATIONAL FURN CO 050660858 "PARAMOUNT" 050660801403 CHAIR
25534 XD CONTEMP 365 799

 

[isa]

Well what do you know, such a simple answer just came to me because of you!!!
I could first sort by collection and then by cost. I feel completely retarded
now!!! Although I do have other worksheets where the collection number is
only on the first row of a group so I could still use some help!
Thanks!
~isa