1st table/report has cells with single values as well as multiple values separated by comma.
<tbody>
</tbody>
if any of the values in the cell is there in the 2nd table I need to filter the 1st report.
2nd table/report
<tbody>
</tbody>
As BE & AA are available in the 2nd table, 1st report should be filtered and should show only the 1st 3 rows (table values with BE & AA )
If the 1st report/table only has single values in a cell I can do a vlookup but as this has comma separated values how should I approach this ?
seeking for immediate assistance as I would need this for my work tomorrow. THANKS
Identifier |
AA |
XY,AA,YX |
BE |
RE,WX,EW,XT |
AB,ER, |
<tbody>
</tbody>
if any of the values in the cell is there in the 2nd table I need to filter the 1st report.
2nd table/report
Identifier |
WR |
AA |
XY |
BE |
<tbody>
</tbody>
As BE & AA are available in the 2nd table, 1st report should be filtered and should show only the 1st 3 rows (table values with BE & AA )
If the 1st report/table only has single values in a cell I can do a vlookup but as this has comma separated values how should I approach this ?
seeking for immediate assistance as I would need this for my work tomorrow. THANKS