I have a Range (Gold) in I1:10 with data 1 to 10 in each cell.
I have a cell (F4) that is the drop down selector fot the Gold Range.
In column J, I have the formula =IF($F$4<=I1,I1,"") so that no number will
appear less than the number selected in F4
I then have another Range for J1:J10 with a cell in G4 to select the numbers
that appear in that range (this is the one that only shows the numbers equal
to or higher than the number selected in F4).
All that works OK, but the drop down box in G4 shows the blank spaces in
column J. In the validation, I have Ignore Blank checked, but the blank
spaces are still showing up in the drop down list.

Thank you...this is driving me NUTS!