Validation List ignore blanks (formula)

[portmontreal]

Hi,

I want to create a validation list with value comming from formula and I got blanks line. I have to create a dynamic list, I can have 15 possibility and it came from a lookup formula. When I choose the 15 cell with the lookup formula it show the empty cell.

I did a exemple of my problem. You can check the attachement to understand my problem in the cell C1.

Best regards

[DonkeyOte]

Alter your Validation List source formula to:

=OFFSET($B$1,,,COUNTIF($B:$B,"?*"),1)

[portmontreal]

Thank you, it work.