I'm noob in spreadsheets so struggling with making dropdown list.
I'm using Google Sheets.
What I want to do is :
I can make INDIRECT at empty cell and make dropdown by list of range, but I have to do same job 1000+ times. so I want to use function in data validation.
But, as you guess, since list of items distinguishes items by comma, I cannot enter multiple arguments function. How can I solve this problem?