Excel Question

[karaokelove]

1st, run a pass to delete 100% matches. Load first question, compare it with every subsequent question, delete 100% matches; load 2nd question, compare it with every subsequent question, and so on until all 100% matches have been dealt with.

Easy way of removing duplicated is to convert then into a set. Doing so will delete all duplicates as in terms of mathematics. For instance

>>> set(list(["hello", "world", "hello", "world"]))
set(['world', 'hello'])

Makes sense?

You are a genius! Yes, that makes total sense. Thanks for the tip!