Data Validation List to skip every other column
I can't seem to get a good formula to return a drop down list using Data Validation for every other cell in a row. I need a dropdown list that produces the values from D9:AR9, the list would only include D9,F9,H9,L9...AN9,AP9 and AR9. I can produce a formula that I can drag across columns to produce the result- OFFSET($B$9,0,COLUMNS($B:B)*2). But I'm not sure how to encapsulate that as the source for the range in Data Validation.
thanks
I'm not sure what you are saying but you choose "list" under the "allow" dropdown menu and the use the formula =$D$9:$AR$9 under source to make it show the values from the cells in a dropdown menu. if this is not what you mean can you upload the workbook then I can take a look at it
if it's because you want it to make a list from an array then you can do it like that because it support only row or columns
Last edited by lafanker; 08-31-2014 at 12:45 AM.
Yes, but I don't want all of the values from D9:AR9. Only the values in every other column.
I don't know if that's possible if so I don't know the answer but then you always have the possibility to make the calculation in a cell and then take the list from there
Please read the forumrules, especialy the one's about crossposting.
http://www.mrexcel.com/forum/excel-q...er-column.html
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Apologies, did not see that rule.
I asked for help on another forum as well:
http://www.mrexcel.com/forum/excel-q...er-column.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks