Is there anyway to filter using multiple criteria: nonblank AND unique?
T the-big-john Dec 14, 2007 #1 Is there anyway to filter using multiple criteria: nonblank AND unique?
D Dave Peterson Dec 14, 2007 #2 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.
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.
