+ Reply to Thread
Results 1 to 3 of 3

Remove 0 from unique filter

  1. #1
    Forum Contributor alexxl's Avatar
    Join Date
    04-21-2015
    Location
    Romania
    MS-Off Ver
    2019/2010
    Posts
    305

    Remove 0 from unique filter

    Atritie exercitiu.xlsm do you have any ideea how i can remove from this context the results of 0 without restricting the area ex: a2:a7, a7 got blanks and because of this the results include 0 (i don`t want to restrict to a2:a6 to solve this).


    Alex

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Remove 0 from unique filter

    Try this,

    Please Login or Register  to view this content.

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: Remove 0 from unique filter

    Or this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] UNIQUE FILTER formula showing only first unique value and not all
    By adyrockstar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-24-2023, 07:45 AM
  2. [SOLVED] UNIQUE FILTER Formula to Mimic "Remove Duplicates"
    By ezekielfu777 in forum Excel General
    Replies: 5
    Last Post: 01-25-2023, 01:23 AM
  3. Filter and copy/overwrite to a new workbook and rename to unique filter value
    By gssc141 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2015, 10:28 AM
  4. Remove Unique | Remove Duplicates
    By Jbrowning1980 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2014, 02:46 PM
  5. Replies: 5
    Last Post: 12-19-2013, 06:58 AM
  6. Filter>Advanced Filter>Unique failure
    By BRISBANEBOB in forum Excel General
    Replies: 2
    Last Post: 06-14-2009, 07:58 PM
  7. unique filter results in some non-unique records.
    By Serials Librarian in forum Excel General
    Replies: 2
    Last Post: 05-26-2006, 05:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1