Hi all, I have done my best to search this and other forums to find a solution to my problem as I thought it would be common however I am yet to find an applicable answer. I have 17500 rows each with a country and a city, I have two combo boxes the first selects the country from a condensed list of 95 countries. I then have an IF function in the column next to the city stating if the country in that row = country selected in 'combo box 1' display city, if FALSE display "".

Then I have a second combo box that has the entire IF city column range selected, of course it displays all 1750 values whether they are a city or just blank (""). It is a pain to have to search through the combo box to find the non blank values.

Sorry for the long winded explanation but essentially what I am trying to do is either:
1. Get combo box to ignore ""
OR
2. populate a new range with only the country selected's cities without all the blanks

Hope this makes sense my programming is very limited but excel skills are quite good,
thanks for any suggestions
-phil