L
Legacy 287389
Guest
Hi good people!,
I have searched but really cannot seem to find. I have numbers 1-100 ranging A1-A100. Then numbers 1-70 ranging B1-B70. In cell D1 I enter values 1 or 2. So, in Cell C1 I have a formula: If(D$1=1,A1,If(D$1=2,B1,"")). This formula is copied down to C100. C1-C100 is the actual drop down list values. The drop down list box is in E1. If I select "2" in D1, the values in column C obviously change to those in column B. If I look at the dropdown now, the list displays the blanks after value 70. How can I have the range adjust to ignore the blanks?. All and any help will be accepted with great humbleness and appreciation. Thank you all..
I have searched but really cannot seem to find. I have numbers 1-100 ranging A1-A100. Then numbers 1-70 ranging B1-B70. In cell D1 I enter values 1 or 2. So, in Cell C1 I have a formula: If(D$1=1,A1,If(D$1=2,B1,"")). This formula is copied down to C100. C1-C100 is the actual drop down list values. The drop down list box is in E1. If I select "2" in D1, the values in column C obviously change to those in column B. If I look at the dropdown now, the list displays the blanks after value 70. How can I have the range adjust to ignore the blanks?. All and any help will be accepted with great humbleness and appreciation. Thank you all..