Filter nonblank AND unique

  • Thread starter Thread starter the-big-john
  • Start date Start date
T

the-big-john

Is there anyway to filter using multiple criteria: nonblank AND unique?
 
I'd use a helper column with a formula like:

=and(a2<>"",countif(a:a,a2)=1)
and fill down

And filter on that helper column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter for blanks - nonblanks problem 1
count how many rows contain nonblank in column A and blank in colu 5
SUMProduct help 4
Unable to Insert Columns 5
Last NonBlank In Ranger 4
Looking uprange for next nonblank cell 4
sort a table that contains both numbers and blank cells 1
show nonblanks 1

Back
Top