Use address function or other

[Doug Laidlaw]

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

 

[Jason Morin]

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(MATCH
("Giants",A:A,0)+MATCH("*",OFFSET(A1,MATCH("Giants",A:A,0)
+1,,1000),0),1,4)

HTH
Jason
Atlanta, GA