Hey All,

I have been working to come up with an excel formula that takes my large data set and looks up the account # and generates all the names associated with that account. Some account numbers have up to ten individuals in the account #. I am looking for a formula that can look up the account # and generate the names within the account.

Thank you