formula to search for text and display all in single cell

[gorelordz]

Hi,

As i'm new to this, i am currently working on small traceability project.

Consider the following table:

Feature ID	TS ID
F1	TS 1.1
	TS 1.2
	TS 1.3
F2	TS 2.1
	TS 2.2
	TS 2.3
	TS 2.4
F3	TS 3.1
	TS 3.2

I want to create a traceability for the TS ID's covered under a feature, like

Feature ID	TS covered
F1	TS 1.1, TS 1.2, TS 1.3
F2	TS 2.1, TS 2.2, TS 2.3
F3	TS 3.1, TS 3.2

To fill each cell for "TS covered" column, i tried using the partial text of "TS 1.?" for F1, "TS 2.?" for F2" and so on. However this is not resolving my issue. Please help

[RobertMika]

Hello and welcome.
You need this:
http://www.xl-central.com/concatenat...n-a-range.html

[:) Sixthsense :)]

Whether the output result can be in separate cells in the right side?

If you want the result to be shown in single cell then we have to go for VBA solution

[gorelordz]

Hello and welcome.
You need this:
http://www.xl-central.com/concatenat...n-a-range.html

Thanks RobertMika. The function is doing as intended, but it is referencing another cell value before concatenating. Can it be done this way- find all entries with partial text "TS1.?" and concatenate those in a single cell?

[gorelordz]

Whether the output result can be in separate cells in the right side?

If you want the result to be shown in single cell then we have to go for VBA solution

Hi Sixthsense. Yes i want the result to be shown in one cell. And what kind of VBA solution would you recommend?

[:) Sixthsense :)]

Check my earlier post for solution in the below link Post # 2

http://www.excelforum.com/excel-prog...on-is-met.html

[gorelordz]

Check my earlier post for solution in the below link Post # 2

http://www.excelforum.com/excel-prog...on-is-met.html

Just so im sure, if the LookUpValue can be a partial string, say "TS 2.?", LookUpRange be the column TS ID, what would be the ResultRange?

P.S: Pardon my silly questions, I'm still a newbie

[:) Sixthsense :)]

Refer the attached file for detail

[gorelordz]

Refer the attached file for detail

Well yes, in the file you attached it works like a charm, but what if the Feature ID column does not repeat the entries? Like this,

Feature ID	TS ID
F1	TS 1.1
	TS 1.2
	TS 1.3

As you can observe, the left cells dont repeat once stated. Can that be done?

[:) Sixthsense :)]

Refer the below links to know how to fill the blank cells quickly

http://www.techrepublic.com/blog/mic...lls-in-excel/#.

http://www.extendoffice.com/document...lue-above.html