Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 6 down vote accepted
  1. Go to the data tab and clock 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.
share|improve this answer

Add an extra column. Use the formula =COUNTIF($A$1:A1,A1) for that column, and copy it to the end

Filter on that column where the value is 1

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .