Hiding blank rows in a drop down data validation list, help please?

Hi, I am trying to hide the blank rows at the bottom of a drop down data validation list.
I think the formula I am using works ok but it doesn't hide the blank rows at the bottom.
The cells being referenced from the formula DL2 are also formulas DI6 to DI254 which I think are the problem as they are not really blank cells.
If I delete to cells that contain formulas that are not being used all is ok but I need the formulas as the list will be different sizes.
I will include a sample workbook.
Many thanks in advance.

You can change your formula to:

=OFFSET(DI5,1,MATCH(DL5,DI5,0)-1,COUNTIF(OFFSET(DI5,1,MATCH(DL5,DI5,0)-1,240,1),"?*"),1)

Hi rorya, Thank you for that, however it works fine for "Orders" but if you change DL5 drop down 1 to "Invoice" or "Unpaid" sadly it does not list anything in DL6 drop down 2. Sorry, "Orders" contains text whereas "Invoice, UnPaid, OverDue" are numbers only.

You could use:

=OFFSET(DI5,1,MATCH(DL5,DI5,0)-1,MAX(COUNT(OFFSET(DI5,1,MATCH(DL5,DI5,0)-1,240,1)),COUNTIF(OFFSET(DI5,1,MATCH(DL5,DI5,0)-1,240,1),"?*")),1)

I'd simplify by making the OFFSET(DI5,1,MATCH(DL5,DI5,0)-1,240,1) part a separate named range