• 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


  • 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

Suresh Badhani

New Member
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


Excel Ninja
Hi ,

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


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.