Excel – Filter for first unique instance a column in Excel

microsoft excelmicrosoft-excel-2010worksheet-function

How can I filter for unique values in a particular column (disregarding the values in the other columns for that row, and so the first instance of a new value would be fine)?

So, for example:

    1   2   3
A   10  a   a2
B   10  g   a3
C   20  h   a3
D   20  k   a3
E   20  l   b4
F   40  m   n6
G   40  q   q2

I would want my filter to show just rows A, C, and F.

Is there an easy way to do this?

Best Answer

  1. Go to the data tab and click on 'Advanced' under 'Sort & Filter';
  2. In the pop up, put the list range as the first column (header included) and check the 'Unique records only' checkbox.
  3. Click OK and that should be it.
Related Question