Forum Discussion
Solved
Combobox return blank for 1st option
Hi, I'm creating a non VBA combobox with the 1st option being "Select" as I need an option to have a null value. I'm referencing the combobox in another formula so can't have "Select" return 1. is t...
- HI,
I used =if(b2=”Select”,c1=”Ascending”,c1=”Descending”) and then added a helper row below to filter out the 1 to use in my next formula. Thanks for your help.
AndyT410 Perhaps in cell C1 you could use =IF(B1=1,"",B1-1), then reference cell C1 instead of B1 in your "other formula".
HI,
I used =if(b2=”Select”,c1=”Ascending”,c1=”Descending”) and then added a helper row below to filter out the 1 to use in my next formula. Thanks for your help.
I used =if(b2=”Select”,c1=”Ascending”,c1=”Descending”) and then added a helper row below to filter out the 1 to use in my next formula. Thanks for your help.
