Hello...
My problem is ...
I m having 10000 raw data (Like sample Below) ...
<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..
<colgroup><col span="8"><col></colgroup><tbody>
</tbody>
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>