Looking up and sorting data.

[TannerLin]

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

[modytrane]

Can you post a sample file with data [de-sensitize data]?
Also, post expected results [even if manually entered].
You'll get help faster that way.