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.