I know how to make a doropdown list using Data>Validity, but is there a way to feed data based on condition?
lets say I have a table whee column A have fruit names, bolumn B have amounts
like:
A | B
Apple | 1
Banana | 3
to make droplist i would do Validity > cell range > $Sheet1.$A$1:$A$2
but what if I want to include only fruits that have amount value of more than 1 in column B ?
is there any way to make Custom criteria to inlude those cells where value in B > 1?
I know this can be done if i make two lists, one with values <=1 and other with >1, however with values changing often, those would need to be recreated, therefore i wonder if this can be achieved with just one table