R
ryan wells
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.
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.