Sorting Groups of Data in Excel 2003

**kyrielynn** · 07-06-2012, 04:30 PM

I apologize in advance if this is hard to understand. I am a newbie and pretty much teach myself, but I can not figure this out!

Is there any way to sort a column of data that is designated to a specific group? I have attached a sample to easier explain what I am trying to do.

In the attachment, there are three groups of data. I need to sort each group by column G (from lowest to highest). Obviously, the stickler here is keeping all the rows within the groups intact. I have a huge spreadsheet of this and I am really dreading the idea of having to do this manually!

Any solutions? Thank you so much in advance.

I am using Excel 2003, but I could possibly use Excel 2010, if their is an option there.

Sample.xls

**Spencer101** · 07-06-2012, 04:38 PM

Maybe I'm missing something here, but there's nothing in column G other than a total for each of the groups.
Did you mean a different column? F Perhaps?

**kyrielynn** · 07-06-2012, 04:40 PM

Yeah. I need to sort column G (the total for each of the groups). I just pulled them out to another column to sort easier. I figured if I didnt, it would sort the other data too, which is not needed.

**JBeaucaire** · 07-06-2012, 04:41 PM

1) Put this formula in H1, then copy H1 down the dataset (the data won't all appear until step #2):

=IF(G1="", H2, G1)

2) Now sort the data by column H ascending.

**kyrielynn** · 07-06-2012, 04:46 PM

Seems like a legit work-around. Worked for me so far. Thank you!

Any other ideas are greatly appreciated.

**Spencer101** · 07-06-2012, 04:44 PM

Right, I get what you mean now.
I shall have to have a think on this one...

EDIT: OR, I would go with JBeaucaire's answer

**JBeaucaire** · 07-06-2012, 04:54 PM

I missed something. You DON'T need the data on the left that goes into making each subtotal? You just want the individual subtotals listed together consecutively?

In K1 put this formula, then copy down:

=IF(ROW(A1)>COUNT(G:G), "", SMALL(G:G, ROW(A1)))

**kyrielynn** · 07-06-2012, 04:58 PM

No, I want to include the data on the left, I just want to sort it by its total. Right now, I have to copy/paste the formula for each to get the weighted average, then type out manually the totals into column G, then do what you first suggested, then sort from there.. then delete those two additional columns. What you have suggested definitely helps- but its still a process.