Using the Unique Filter Function and Sorting by Count Column

**emerdmann** · 08-29-2022, 11:38 AM

Cell D3 is a dropdown menu and cell E3 is a dependent drop down menu that populates housing categories based on the neighborhood chosen in D3. Cell D5 holds a UNIQUE/FILTER function to get a list of all the housing categories in Brewerytown:
Capture.JPG

In cells E5:E10 I used a simple COUNTIF function to count the number of properties in each category.

I would like to sort column D5:D10 from largest to smallest based on column E5:E10. I would like the result to be:

Single Family 9135
Vacant Land 3865
Multi Family 2154
etc.

Is this possible?

**AliGW** · 08-29-2022, 11:45 AM

Have a look at the SORTBY function: https://support.microsoft.com/en-us/...1-d6a35134f28f

If you want us to show you, attach a workbook - we can't work with a picture.

**HansDouwe** · 08-30-2022, 12:03 AM

SORT is also possible in this case. Please try

Formula:

Please Login or Register  to view this content.

Using the Unique Filter Function and Sorting by Count Column

LinkBack

Thread Tools

Rate This Thread

Display

Using the Unique Filter Function and Sorting by Count Column

Re: Using the Unique Filter Function and Sorting by Count Column

Re: Using the Unique Filter Function and Sorting by Count Column

Thread Information

Users Browsing this Thread

Similar Threads

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

[SOLVED] Count the number of Unique Items in a Column for each Unique Item in another Column

[SOLVED] Count unique occurences in one column with unique occurances in another column

[SOLVED] Count Unique Values with FILTER ON

[SOLVED] Count Unique function in sheet with data filter applied

Count unique + filter

Filter unique, and then count

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions