Suresh Badhani
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
n 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.