Update Validation list from another cell

  • I am creating a spread sheet containing responses from employees from various firms.
    Among the criteria which forms part of AutoFilter criteria, there is a value for the employees Year of Experience.


    Based on the layout of the responses, I have a macro to take the chosen criteria and applies it to the AutoFilter range.


    I have used Data Validation to limit the criteria to only those values present in the response.




    In the attached I want the Experience criteria to be a range, but want to limit the list so that the upper value cannot be less than the lower value.
    For example, if I choose 7 in cell B1, the list returned in cell D1 only shows "8,9,10".




    Does anyone have any idea on how I can achieve this?


    Thanks

  • Try:


    =OFFSET(Experience,B1,,MAX(Experience)-B1,1)

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!