Error in Data Validation List using Offset Function in Excel || (the source currently evaluates to an error)

[scorpene]

i used following formula to extract unique values from a list- =IFERROR(INDEX(Table_AMIS[UPLIFTDATE],MATCH(0,INDEX(COUNTIF($AH$1:AH1,Table_AMIS[UPLIFTDATE]),),0)),"")

Now in order to create a drop down list from the above distinct list i put the following formula in data validation field: =OFFSET(SS_1!AH2,,,COUNTIF(SS_1!AH2:AH50,"?*"))

But i get this error "the source currently evaluates to an error". The field which i am trying to extract contains dates only. . When remove the question mark from offset formula then the values starts flowing in the drop down but along with the blank spaces. But i don't want the blank spaces.

Please help !!

 

[Fluff]

How about
=OFFSET(SS_1!AH2,,,COUNTIF(SS_1!AH2:AH50,">0"))

 

[scorpene]

Thank you so much @Fluff . You're a savior . God Bless you .

 

[Fluff]

You're welcome & thanks for the feedback.