+ Reply to Thread
Results 1 to 3 of 3

Extract filter, sort, count a unique distinct values from filtered list in Column A.

  1. #1
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    115

    Extract filter, sort, count a unique distinct values from filtered list in Column A.

    Hi,

    Required a formula help to extract filter, sort a unique distinct values from filtered list in Column A without blank cells, and for the same required numbers of count in Cell B26.


    Sample sheet attached.



    Thanks,
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    6,956

    Re: Extract filter, sort, count a unique distinct values from filtered list in Column A.

    Please try at
    A26
    =SORT(UNIQUE(FILTER(A5:A23,SUBTOTAL(3,OFFSET(A5,SEQUENCE(ROWS(A5:A23),,0),)))))

    B26
    =COUNTA(UNIQUE(FILTER(A5:A23,SUBTOTAL(3,OFFSET(A5,SEQUENCE(ROWS(A5:A23),,0),)))))
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    115

    Re: Extract filter, sort, count a unique distinct values from filtered list in Column A.

    Many thanks Bo ry for the formula solution.

+ 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. Extract unique values from filtered column
    By Journeyman3000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2020, 09:38 PM
  2. Count Distinct Values With A Criteria In A Filtered List
    By JonnyBoy333 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2019, 02:52 AM
  3. Extract Unique Values from Filtered List
    By kruss777 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2019, 02:09 PM
  4. [SOLVED] How to count unique distinct values from a column where values in other column exists ?
    By Daniel Tou in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-19-2017, 05:48 PM
  5. 2-Column List of Unique Distinct COMBINED Values
    By probladerunner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-19-2016, 09:05 PM
  6. Extract unique text values from a filtered list
    By ljerromes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2015, 07:51 PM
  7. Filter for unique values on an already auto-filtered list?
    By dylanemcgregor in forum Excel General
    Replies: 1
    Last Post: 01-11-2010, 07:25 PM

Tags for this Thread

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