Using Sort With Filter

How to use the SORT function with the FILTER function.

Watch the video below:

How to use the SORT function with the FILTER function.

In the last video we learnt how to use the FILTER function. We used a simple criteria to analyze our data. Next we used multiple criteria to analyze the same data to extract more specific information.

The formula below allowed us to analyze our data based on the product ‘Laptop’ criteria: FILTER(A5:D30,(C5:C30=G2),””)

Range A5:D30 represents our ARRAY of data.

Range C5:C30 represents the data in the Product column.

G2 = Laptop and represents the criteria

Quotes “” represent a BLANK if no data is found (if_empty)

Filter Function Using Single Criteria
Filter Function Using Single Criteria

The Filter function using the multiple criteria on the same data gives the following result: =FILTER(A5:D30,(C5:C30=G2)*(A5:A30=J2),””)

Range A5:D30 represents our ARRAY of data.

Range C5:C30 represents the data in the Product column.

G2 = Laptop and represents the criteria

* represents AND

Range A5:A30 represents the data in the Region column

Range J2 has West as value and represents the second criteria

Quotes “” represent a BLANK if no data is found (if_empty)

Filter Function Using Multiple Criteria
Filter Function Using Multiple Criteria

Next we use the SORT function to sort the Units Sold in in column 4 in descending order (-1):

=SORT(FILTER(A5:D30,(C5:C30=G2)*(A5:A30=J2),””),4,-1)

Using Filter Function with Sort Function
Using Filter Function with Sort Function

How do we sort the filtered data in ascending order. We use the following formula:

=SORT(FILTER(A5:D30,(C5:C30=G2)*(A5:A30=J2),””),4,1)

Sorting Filtered Data in Ascending Order
Sorting Filtered Data in Ascending Order

Published by

Dinesh Kumar Takyar

Welcome to exceltrainingvideos.com! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: http://youtube.com/familycomputerclub For a structured Excel VBA training course online you can visit: https://www.youtube.com/excelvbaonline

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.