Hi,

Excel amateur, wondering if anyone can help?

I have a list of data in the format 'a/b/c' - these will be team names.

What I need to be able to do is put in new data into a table in the
format 'a vs b' and then have a macro/formula to search for a and b in
the first list of data and remove any entries that include those two.
So that the data a/b/c only contains "legal" entries, i.e. not two
names that are facing each other in the other list.

Does this make any sense to anyone, I dont forsee it being too complex
but like I say I am a bit of a novice in Excel.

Thanks in advance,

T. Robertson