Find the cell location(s) in which a comma separated list of items are contained

[raver4ever]

I have a set of data which is hyphen separated as follows:

1-3-4-6-7-8-9	A4
3-4-6	A1&A4
6-8-9	A1&A4
1-3-4-6-7-8-9-0	Not Found

My objective is to find the cell location(s) in which I can find the cell string as a subset. If the string is not found as a subset on any other cell except itself I want to flag it as "Not found"

Is excel able to help me with a quick solution on this?

 

[BSALV]

manually, one by one or with VBA ?

 

[raver4ever]

manually, one by one or with VBA ?

Via VBA or formula, I have hundreds of rows it is not scalable to do it manually