Sadiqmcool
New Member
- Joined
- Jun 7, 2017
- Messages
- 1
Hi Friends,
i Have a difficult question to explain.
As you see in below table, columns in green i have, column in red i am trying to get as result.
Problem statement:
Values of B column it should search in range (B2:B5), if a comma separated string is occurring in the range then it should return the in which all cells it is available.
Example:
abc form cell B2 is repeated in B4.
hij from cell B2 is repeated in B3 and so on
Expected result is shown in duplicate column
[TABLE="class: grid, width: 366"]
<colgroup><col span="3"><col></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Teams[/TD]
[TD]Count[/TD]
[TD]Duplicate[/TD]
[/TR]
[TR]
[TD]Boys_19[/TD]
[TD]abc, hij,
xyz[/TD]
[TD="align: right"]3[/TD]
[TD]Boys_19 Girls_19 Boys_14[/TD]
[/TR]
[TR]
[TD]Girls_19[/TD]
[TD]efg, hij[/TD]
[TD="align: right"]2[/TD]
[TD]Boys_19 Girls_19[/TD]
[/TR]
[TR]
[TD]Boys_14[/TD]
[TD]nop, qrs,
abc[/TD]
[TD="align: right"]3[/TD]
[TD]Boys_14 Boys_19[/TD]
[/TR]
[TR]
[TD]Girls_14[/TD]
[TD]klm, afo[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Thank you
i Have a difficult question to explain.

As you see in below table, columns in green i have, column in red i am trying to get as result.
Problem statement:
Values of B column it should search in range (B2:B5), if a comma separated string is occurring in the range then it should return the in which all cells it is available.
Example:
abc form cell B2 is repeated in B4.
hij from cell B2 is repeated in B3 and so on
Expected result is shown in duplicate column
[TABLE="class: grid, width: 366"]
<colgroup><col span="3"><col></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Teams[/TD]
[TD]Count[/TD]
[TD]Duplicate[/TD]
[/TR]
[TR]
[TD]Boys_19[/TD]
[TD]abc, hij,
xyz[/TD]
[TD="align: right"]3[/TD]
[TD]Boys_19 Girls_19 Boys_14[/TD]
[/TR]
[TR]
[TD]Girls_19[/TD]
[TD]efg, hij[/TD]
[TD="align: right"]2[/TD]
[TD]Boys_19 Girls_19[/TD]
[/TR]
[TR]
[TD]Boys_14[/TD]
[TD]nop, qrs,
abc[/TD]
[TD="align: right"]3[/TD]
[TD]Boys_14 Boys_19[/TD]
[/TR]
[TR]
[TD]Girls_14[/TD]
[TD]klm, afo[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Thank you