What I am trying to accomplish is like using a SELECT DISTINCT in SQL.
I already know of formula arrays and the ribbon buttons, but that is still not enough.
The constraints I am working with are:
I have 2 Excel tables
One has duplicate values in one column.
I have to get only the distinct values in the second column.
Can you folks help me on that?