Forum Discussion
Help with data valiation (indirect function)
Hi, I have a list of tests reports I need to pull based off specific criteria from each drop down. I already have the list established but I need it to be dependent for each choice. Exam...
novakdz Similar to a problem that came up earlier today in this thread.
Working with Named Ranges and INDIRECT will enable what you want to achieve, though you have to restructure your option lists.
Yes but where I got stuck was the duplicate data. I can’t remove it, I have to reference all the data in each category since each final test is different.
I was trying to make a drop down list like this: https://www.xelplus.com/extract-unique-items-for-dynamic-data-validation-drop-down-list/
but I couldn’t figure it out the formula was too complex.
Please let me know if you have any recommendations,
Thank you
I was trying to make a drop down list like this: https://www.xelplus.com/extract-unique-items-for-dynamic-data-validation-drop-down-list/
but I couldn’t figure it out the formula was too complex.
Please let me know if you have any recommendations,
Thank you
Must admit I'm progressing slowly. But, if you would consider to reorganise your lists (started with an example in Sheet1 in the attached workbook), I'm confident it can be achieved. But now I must, unfortunately go off-line for a while.
- I appreciate all your help I was able to watch the video and download the spreadsheet to create my unique validation list. Now I’m using this video and spreadsheet to do the rest. https://youtu.be/gu4xJWAIal8
Thank you again for your help.