There are two data validation dropdowns. There is category and a iten belongs to the category. Now needed is a worksheet change event that triggers this:
If the user selects a category, then first it looks at the numbers of the items that lie in that category range, if the number of items in that category range is more than one, the second dropdown shows “ALL “ by default.
On the other hand, if the category range has only one item in the list, then it shows that one item for the itemChoice range by default
For example: If I select category 1, I get to see “ALL” by default for the item dropdown. If I select category2, then item dropdown gets the first item [a2] shown in the item choice dropdown