grouping cells and sorting

  • Thread starter Thread starter rgilles
  • Start date Start date
R

rgilles

I have set-up an excel spreadsheet that encompasses several lines tha
are all related to each other so when I sort the worksheet I want t
keep those groups together. For instance if the spreadsheet liste
vehicles line 1 would be the make and model and line 2-5 would lis
options on this vehicle. Is it possible to sort the page keeping th
options with the vehicle
 
Not possible without some modification.

Assuming Column A holds Vehicle

Select Column A and Edit>Go To>Special>Blanks and OK

In Active Cell type = sign then mouse-point and click on cell above.

Hit CRTL + Enter.

The Vehicle will be repeated down column A and change at each new Vehicle.

You can copy Column A and(in place) Paste Special>Values>OK>Esc.

Select all columns and sort on column A.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Subtotals do not add properly 5
Sorting within Groups 3
Acoustics - 80Hz loss in car! 0
Merging Cells and Sorting 1
Automatically Assign Stock Number By Model 12
Confounded by date differences 3
Compare Two Cells 1
Add rows on worksheet by date? 6

Back
Top