Hi,
I'm trying to remove the cells that contain a value from multiple other cells.
So I have two lists with data and I would like to remove every cell from the one list, which contains anything that is in the second list.
for example the first list could look like this:
the second one like this:
and now I'm trying to remove the cells from the first list that contain any of the cities in the second list
I'm trying to remove the cells that contain a value from multiple other cells.
So I have two lists with data and I would like to remove every cell from the one list, which contains anything that is in the second list.
for example the first list could look like this:
- miami school scholarships
- funding for school
- gauteng school holidays 2015
- gems school
- london school
- heritage oak school
- horizon school
the second one like this:
- new york
- paris
- london
- rome
- miami
- barcelona
and now I'm trying to remove the cells from the first list that contain any of the cities in the second list