This is a very clumsy solution. Ignore it if a better one is posted:

Say the data is in column B rather than column A. From B1 thru B10:

anteater
bird
cat
dog

elephant
flea

gyron
horse

As in your case both B5 and B8 are empty. In A1 enter 1 and in A2 enter:
=IF(B2="","",MAX($A$1:A1)+1) and copy down. We now have:

1 anteater
2 bird
3 cat
4 dog

5 elephant
6 flea

7 gyron
8 horse

Now we can use VLOOKUP() on column A. In C1 enter:
=IF(ISERROR(VLOOKUP(ROW(),A:B,2,FALSE)),"",VLOOKUP (ROW(),A:B,2,FALSE))
and copy down:

1 anteater anteater
2 bird bird
3 cat cat
4 dog dog
elephant
5 elephant flea
6 flea gyron
horse
7 gyron
8 horse

Column C is like column B except all empties have been removed.

Use column C as the validation list rather than column B

--
Gary''s Student - gsnu200773


"FARAZ QURESHI" wrote:

Cells A1:A10 show a result from a formula. A5 is containing no formula and A8
reflects "" as a formula result.

Now when I select the range A1:A10 in DataValidationList source being
A1:A10 I want only the results which are neither Blank nor "" but the drop
down list still reflects blank spaces of A5 & A8, although the "Ignore
Blanks" have been checked.

All expertise and guidance shall be obliged.

Thanx in advance!

--

Best Regards,
FARAZ A. QURESHI