Hi,

I have been following all your posts on your youtube.

Just recently, I have learned how to extract records with multipole criteria’s dynamically. However, I still don’t know how to extract records when one of the criterias cells is blank

For example, if I am extracting using 4 criterias, (date-sales-region-salesman). For this, I have created 4 dropdown cells.

What I need to do is to leave the salesman cell blank, but still extract the rows that matches the 3 other criterias data-sales-region

Many Thanks,
Saud