• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel dependent drop down list with filter all

When we make dependent drop down list in excel then that can filter data which we give in list . is there is possible there we add All in list , when we select ALL give all data from row
 
Plz find support data . query that if i select all in drop down can filter for all dependent
 

Attachments

  • all data.xlsx
    333.1 KB · Views: 14
Hi ,

In cell C3 , where you have the COUNTIFS formula , the last criterion at present in the formula is :

$AK$1

Replace this by :

IF('service by'!$AK$1 = "All", $AJ$1&"*", $AK$1)

Copy across and down to all the other cells in your output range.

Narayan
 
Back
Top