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