Group into rows by every change of Column A

[Jan]

I have a 3,000+ line worksheet with data about every member at our
country club. The member # is in Column A.

Each member # might have 20 rows of data that I want to keep in a
group.

Perhaps I am using the wrong term, however....

First I imported the raw data, then I sorted by member # (Column A)

Then, I needed sub-totals for the rounds of golf and the revenue, so:

For every change in member # in Column A, I subtotaled other columns.

That is the beauty of the sub-total feature.

Now, I want to sort by the member with the most rounds of golf,
however, I want all of the data of the member kept together.

How can I group the rows with the same member #?

Perhaps I am using the wrong term as "group."

Thank you in advance for any help you can give me.

 

[Bernie Deitrick]

Jan,

Now you need to use another feature of Excel, Pivot Tables. Select your data, then choose Data /
Pivot table.... and click Finish or Ok. Then drag the Name button to the row field area, and the
golf rounds to the data field area, and set the field to SUM. Then you can sort that table
descending.

HTH,
Bernie
MS Excel MVP

 

[Jan]

Jan,

Now you need to use another feature of Excel, Pivot Tables.  Select yourdata, then choose Data /
Pivot table.... and click Finish or Ok.  Then drag the Name button to the row field area, and the
golf rounds to the data field area, and set the field to SUM. Then you cansort that table
descending.

HTH,
Bernie
MS Excel MVP
















- Show quoted text -

Thank you very much...I have not worked with Pivot tables before...I
am going to try that!!