Exclude blanks in data validation with Indirect
Hello again. I have a problem with how to exclude the blanks in a data validation in the tData of the Data sheet. I have read something about OFFSET but I do not know where in the validation formula will I paste the =OFFSET($A$1,0,0,COUNTA($A:$A),1).
And, is there a way to extend the window of the dropdown to the bottom of the screen so that more items will appear instead of using the vertical scroll down?
Thank you.
|