Hello all -
I have an excel sheet which generates a price of a particular piece based on several criteria.
In my data validation, I have this formula - =OFFSET(Price!$C$2:$C$21,0,A3-1)
When the user enters a diameter for a particular piece (or row), this generates the possible "widths" for that diameter which becomes a drop-down.
For some diameters, the widths are BLANK, or they don't exist in that range C2:C21.
Is there any way to filter out the blanks so that my drop-down contains only numbers, without using nested if statements?
Thank you!
Bookmarks