Excel 2007 : Excel Concatinate formula

[nikhil.sikka]

Hi Guys.

I am new to this forum. Would like you to help me in for a small favor in Excel 2007.

I have added an excel sheet with sample data. here i am looking for all possible job names against a particular store id. plz help..

Regards
Nikhil Sikka

[DonkeyOte]

Using the sample:

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

However, with as bigger a data set as you say you have you should look to use VBA (UDF).
If you must use formulae then you should sort your data by store id so as to facilitate more efficient methods than the above.