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.
Add a data validation list to your input cells and set the list reference to:
=OFFSET(F4, 0, 0, H3, 1)