I need your help with creating a conditional name range. Here's what I have thus far.
Cells A1:A10 are saved as name range "Customers". I then use that name range ("Customer") as a drop-menu in another cell.
Some of the 10 customers (naturally, I have more in reality), however, had not made a purchase yet. That is, customer in A3 or A6 or A10 have placed 0 orders. Therefore, I want my drop-down menu to only include the other 7 customers (A1, A2, A4, A5, A7, A8, A9). Once, any (or all) of the other three customers placed an order, I want the drop-down menu to reflect that change and show up to 10 customers.
My question: How can I create this dynamic name range (drop-down menu) where I only include customers where value in B1:B10 is greater than 0?