How to select partial values from drop down list not all

From the picture, what I want is when the user input the wanted value in [H3]. If i have 10 values in the table and the user input 5. I want the dropdown list to show only 1 to 5.

enter image description here

1 answer

  • answered 2019-10-08 06:00 Tim Williams

    Add a data validation list to your input cells and set the list reference to:

    =OFFSET(F4, 0, 0, H3, 1)