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

**Mohammad Munawar** · 11-23-2020, 06:54 AM

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,

**Bo_Ry** · 11-23-2020, 08:24 AM

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),)))))

**Mohammad Munawar** · 11-23-2020, 12:03 PM

Many thanks Bo ry for the formula solution.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Extract unique values from filtered column

Count Distinct Values With A Criteria In A Filtered List

Extract Unique Values from Filtered List

[SOLVED] How to count unique distinct values from a column where values in other column exists ?

2-Column List of Unique Distinct COMBINED Values

Extract unique text values from a filtered list

Filter for unique values on an already auto-filtered list?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions