Create a unique list in Excel based on criteria

This post poses a problem: create a unique list in Excel based on criteria. Rather than just presenting a solution, the author helpfully walks us through how to understand the complicated formula that solves the problem.

The key point is that if you find a formula online and simply copy / paste it without understanding how it works, you limit yourself from the power it has, and therefore, you limit the power that you have.