Every time a specific value appears in Column A, I need to group the
corresponding values in Columns B,C, and D. For example, with the following
data:

Arizona Phoenix 28 12
Nevada Reno 36 17
Arizona Tucson 39 43
Texas Houston 16 29
Montana Helena 34 66

I need to group every occurance of Arizona and the info to its right on a
selected couple of rows. I need to disregard everything else. My solution
should be:

Arizona Phoenix 28 12
Arizona Tucson 39 43

Help.

Click on the Top-left Arizona and Highlight (By Drag over all the cells down
thru
the cell containing the value 66.
Then at the Menu click on Data, Sort (in the 1st box) select Arizona
(Ascending)
(In the Second box) select Phoenix (Ascending) Check Has no header.
and then OK...


"Mark Hughes" wrote:

Every time a specific value appears in Column A, I need to group the
corresponding values in Columns B,C, and D. For example, with the following
data:

Arizona Phoenix 28 12
Nevada Reno 36 17
Arizona Tucson 39 43
Texas Houston 16 29
Montana Helena 34 66

I need to group every occurance of Arizona and the info to its right on a
selected couple of rows. I need to disregard everything else. My solution
should be:

Arizona Phoenix 28 12
Arizona Tucson 39 43

Help.

It has to be done automatically, without using the sort feature. I can't
touch the data.


"JMay" wrote:

Click on the Top-left Arizona and Highlight (By Drag over all the cells down
thru
the cell containing the value 66.
Then at the Menu click on Data, Sort (in the 1st box) select Arizona
(Ascending)
(In the Second box) select Phoenix (Ascending) Check Has no header.
and then OK...


"Mark Hughes" wrote:

Every time a specific value appears in Column A, I need to group the
corresponding values in Columns B,C, and D. For example, with the following
data:

Arizona Phoenix 28 12
Nevada Reno 36 17
Arizona Tucson 39 43
Texas Houston 16 29
Montana Helena 34 66

I need to group every occurance of Arizona and the info to its right on a
selected couple of rows. I need to disregard everything else. My solution
should be:

Arizona Phoenix 28 12
Arizona Tucson 39 43

Help.

Mark

Have you tried DataFilterAutofilter?


Gord Dibben MS Excel MVP

On Mon, 30 Apr 2007 18:32:01 -0700, Mark Hughes <Mark
wrote:

Every time a specific value appears in Column A, I need to group the
corresponding values in Columns B,C, and D. For example, with the following
data:

Arizona Phoenix 28 12
Nevada Reno 36 17
Arizona Tucson 39 43
Texas Houston 16 29
Montana Helena 34 66

I need to group every occurance of Arizona and the info to its right on a
selected couple of rows. I need to disregard everything else. My solution
should be:

Arizona Phoenix 28 12
Arizona Tucson 39 43

Help.