I have a column id which I need to check if all values within that id per cell is available in another list of IDs
ex:
id |
0786,0982,7923,A913 |
0389 |
0917,0982 |
7923,A913,0917 |
LIST
0786 |
0982 |
7923 |
0917 |
hence output will be:
1st id = FALSE, as A913 is not in list
2nd id = FALSE, as 0389 is not in list
3rd id = TRUE, as both 0917 and 0982 are in list
4th id = FALSE, as A913 is not in list
Solved! Go to Solution.
@toxicboy
We can also go with the approach below.