Filter Unique Sort but ignore blanks & zeros

**KerahJoy** · 03-15-2023, 09:53 AM

I have a filter/sort/unique formula which should ignore blanks but does not seem to be working. Ideally I would like for filter to ignore both blanks and zeros.

Any suggestions? Thanks

**KOKOSEK** · 03-15-2023, 09:57 AM

Try:

Formula:

=SORT(UNIQUE(FILTER(Table12[Roles],(Table12[Roles]<>0)*(Table12[Roles]<>""))))

**KerahJoy** · 03-15-2023, 11:31 AM

that worked thanks

**KOKOSEK** · 03-15-2023, 11:34 AM

Happy to help.

Filter Unique Sort but ignore blanks & zeros

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Filter Unique Sort but ignore blanks & zeros

Re: Filter Unique Sort but ignore blanks & zeros

Re: Filter Unique Sort but ignore blanks & zeros

Re: Filter Unique Sort but ignore blanks & zeros

Thread Information

Users Browsing this Thread

Similar Threads

Need help with a formula to average a range, ignore blanks but NOT zeros

Index match duplicate values, need to ignore zeros or blanks in range

[SOLVED] Sum Product Ignore Blanks or Zeros

Ignore Blanks and Zeros

[SOLVED] Ignore Blank, zeros in a range sort

Automatically Ignore/Filter/Sort Blanks from a Pivot Table before creating Chart Using VBA

Ignore blanks or zeros

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions