ExcelBanter - Filter nonblank AND unique

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter nonblank AND unique (https://www.excelbanter.com/excel-discussion-misc-queries/169698-filter-nonblank-unique.html)

the-big-john[_2_]

Filter nonblank AND unique

Is there anyway to filter using multiple criteria: nonblank AND unique?

Dave Peterson

Filter 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.

the-big-john wrote:

Is there anyway to filter using multiple criteria: nonblank AND unique?

--

Dave Peterson

All times are GMT +1. The time now is 08:40 AM.