Hello,
I would like to remove items from dropdown list when value that is attributed to that item equals 0
Label Amount
Book1 5
Book2 2
Book3 0
In this example I would like to remove in dropdown list (data validation) book 3, because value for amount is 0.
Can you please help me with the correct formula?
Thank you.
Bookmarks