Hi
see your post in Excel.worksheet.functions

--
Regards
Frank Kabel
Frankfurt, Germany


ryan wells wrote:
Hello...

I was be so grateful if some Excel Expert could offer a solution to
this problem I have understanding how to handle arrays in Excel.

I have a worksheet contains a list of events down the page [in column
one], and a list of athletes aross the page [in row one].

I need to note which athletes will compete in which events by placing
a character in the corresponding cell to make an array of data
showing
athlete participation in events.

Athletes can be in more than one event.

I need to then work out how to write a formula or function to
generate
a list from this array showing which athletes are in which event, ie.
a (semi-colon) delimited cell per event containing all the (summary
of) athlete names in that event, eg.

Cell 1,1: "400m" Cell 1,2: "Arthur Burke; Audrey Smith; Betty Brown"
Cell 2,1: "800m" Cell 2,2: "Arthur Burke; Betty Brown; Charlie
Smith"

etc.