Forum Discussion
named range drop-down list doesn't allow selecting the same value for multiple rows, any workaround
A value in a named range dropdown can be selected for only one row, the selected value is not available for subsequent rows. Manually entered values for a drop down list doesn't have this limitation....
You are mixing terms here--"named range" and "dropdown"--in ways that make it hard to follow you, to picture what you're trying to describe. For one thing, both named ranges and drop-downs (AKA data validation) can definitely be applied to multiple rows, contrary to what you appear to be saying. So no work-around should be necessary, unless what you're attempting is something altogether different.
Please, therefore, come back with a more complete description, perhaps (ideally) posting a copy of the actual workbook on OneDrive or GoogleDrive, with a link pasted here that grants access.
- Figured it out, by following https://www.contextures.com/xldataval01.html . made a mistake in defining name (in Name Manager).
