Help....!

[EC_08]

Hello...

My problem is ...

I m having 10000 raw data (Like sample Below) ...

Person	Red	Amber	Green	Violet	Pink	Saffron	White	Output
A	Yes		Yes		Yes		Yes	Red/Green/Pink/White
B		Yes				Yes		Amber/Saffron
C				Yes			Yes	Violet/White
D	Yes	Yes						Red/Amber
E	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Red/Amber/Green/Violet/Pink/Saffron/White

<tbody>
</tbody>

in A column person A,B,c....having different colour (Coloumn B to H)

i want output in cell I like if person A having Red & Green Colour Output is Red/Green..
if person B having Amber & Pink & white then Output should be Amber/Pink/White..etc..

Person	Red	Amber	Green	Violet	Pink	Saffron	White	Output
A	Yes		Yes			Yes	Yes	Red/Green/Saffron/White
B		Yes			Yes		Yes	Amber/Pink/White

<colgroup><col span="8"><col></colgroup><tbody>
</tbody>

 

[Peter_SSs]

You didn't say whether you wanted the UDF approach or standard formula.

For UDF approach use exactly the same UDF code I gave you before and when you enter the formula in the worksheet use the optional text to look for as shown below.
For standard formula, replace all the "=" signs (except the first ) in my earlier formula with "<>"

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Person	Red	Amber	Green	Violet	Pink	Saffron	White	Output	Output
2	A	Yes		Yes		Yes		Yes	Amber/Violet/Saffron	Amber/Violet/Saffron
3	B		Yes				Yes		Red/Green/Violet/Pink/White	Red/Green/Violet/Pink/White
4	C				Yes			Yes	Red/Amber/Green/Pink/Saffron	Red/Amber/Green/Pink/Saffron
5	D	Yes	Yes						Green/Violet/Pink/Saffron/White	Green/Violet/Pink/Saffron/White
6	E	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Headings