Using unique with multiple filters to exclude values

[Bravo2003]

I have this formula to sort a list of for unique account numbers - all works great with this,
=SORT(UNIQUE(FILTER($B:$B,$A:$A=$O$1)),,-1)

But I also need to exclude from the list any results that have a "0" in column D

Can't quite work how how to add this exclusion to the workings?

 

[Fluff]

How about

=SORT(UNIQUE(FILTER($B:$B,($A:$A=$O$1)*(D:D<>0))),,-1)

 

[6StringJazzer]

Modify your formula to:

=SORT(UNIQUE(FILTER($B:$B,($A:$A=$O$1)*($D:$D<>0))),,-1)

 

[Bravo2003]

Excellent, thanks.
I was trying to work that one out and realise now I was missing adding a ( before A:A & an extra ) after.

All sorted now, thanks

 

[Fluff]

Glad we could help & thanks for the feedback.