Exclude blanks in data validation with Indirect

[Marcia]

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.

[p45cal]

Look at formulae in sheet Peritem cells A2:C2.
If you find have repeating items in those lists you can wrap the formula with UNIQUE
Look at the Names aaa, bbb & ccc and note the # character at the end.


Look at the formula in cell F2 of sheet List.
Look at the data validation in cells A2:A4 of the Data sheet, and note the # character.
The data validation in cells B2:B4 of the same sheet haven't changed.

[Marcia]

Hi. It took me quite some time to get back. I applied the formulae to my actual workbook and it is perfect. The FILTER kicked aside the loooonnngg INDEX MATCH functions.
I cannot say enough thank you for all your generous help and sharing your expertise. I feel embarassed seeing in this forum the "Expert" tag below my name.