Hi,

I am trying to do something which is pretty easy conceptually, and can
be done pretty easily with a macro, but I'd like to do it in a single-
cell formula.

In Sheet1, say I have two columns: Names and Group. Let's say that
there are 10 groups total, and 500 Names, but Names can repeat, and
there can be the same name within the same Group.

What I want to do in Sheet2 is have, say 'Group 1' in cell B2, and
then below it, list each name that belongs to Group 1 below it. If
there is a name that is in Group 1 more than once, I want to list it
as many times as it occurs (but if it's easier to list just once, that
could work also).

The column with the Names is alphabetical, so after you're finished
with Name1, it won't be repeated after Name2 begins. Group 1 is in no
order other than to correspond with the name.

I think it's a function of combining OFFSET, MATCH, INDEX, and/or
CHOOSE, but not really sure what to do after I get the first one.

Thanks!

Brett