[SOLVED]Dependent data validation from pivot tables

[SavageMoon]

ive never posted here so sorry for formating
its an old example but it worked really well.
however Im running into a situation where my "State" is somehow limiting the amount of data i can pull.

these are my data validation formulas im using in my program
so in my pivot table my list of "states" goes to around 13000
however my list of "CITIES" goes far beyond that about row 20000

coincidentally the i cant pull any "cities" that go past 13000
so to test i added another "STATE"
and now i can pull up to 13001

why is my formula restricting the amount of data i can pull.

does the offset mess with this?
i used it to keep my program running no matter how many "States" are added.

Please Login or Register  to view this content.

I hope someone can help me with this.
and hopefully i dont look completely lost lol


in the image anything under the red line cant be seen in a the city data range
help.PNG

[SavageMoon]

Never mind. Didnt realize that counta didnt count blank spaces so i had it count the cities instead of states