Use address function or other
 

I want a formula to show me the cell range of a group of data. In the below
example which looks like a piviot table result, what formula can I put in
cell C5 to tell me that "Giants" ranges from A5:A8. I want the formula to
give me A5:A8.

A B
5 Giants Jeff
6 Steve
7 Bob
8 Dave
9 Mets Ralph
10 Phil

Not sure what you're trying to achieve, but you could
piece together the range using:

=ADDRESS(MATCH("Giants",A:A,0),1,4)&":"&ADDRESS(MA TCH
("Giants",A:A,0)+MATCH("*",OFFSET(A1,MATCH("Giants ",A:A,0)
+1,,1000),0),1,4)

HTH
Jason
Atlanta, GA

-----Original Message-----
I want a formula to show me the cell range of a group of
data. In the below
example which looks like a piviot table result, what
formula can I put in
cell C5 to tell me that "Giants" ranges from A5:A8. I
want the formula to
give me A5:A8.

A B
5 Giants Jeff
6 Steve
7 Bob
8 Dave
9 Mets Ralph
10 Phil

.