
25 February 2017
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.
Full article: Create a unique list in Excel based on criteria