excelexcel-formulaexcel-2010

Excel drop-down list items start from middle of column of Table to end by using spill operator "#"

I have a table for example 8 rows and two drop down list, I want first drop down list has items from 1 --> 4 and the two drop down list has items from 5 --> end

The problem is in the drop down list two cos I used spill operator "#" in source and not work

enter image description here

enter image description here

enter image description here

Solution

  • How about using OFFSET instead?

    =OFFSET(A6,0,0,COUNTA(A:A)-5,1)