Forum Discussion
Alvarom1
Oct 06, 2023Copper Contributor
Data Validation with unique values
Hi, I have a question on Data Valitation. I have a list with duplicated values on it. I do data validation with this list to get a drop list. When done with one computer I get a drop list with onl...
HansVogelaar
Oct 06, 2023MVP
What are the versions of Excel on the two computers?
Alvarom1
Oct 06, 2023Copper Contributor
Computer 1 - Version 2309 (16827.20130) (shows unique values)
Computer 2 - Version 2303 (16227.20318) (shows same values repeated)
I checked same file with a thrid computer MAC - with version 16.77.1 (23091703) and shows also values repeated).
Computer 1 is the only one that shows correctly only unique values in the drop down list
Thanks!
Álvaro
Computer 2 - Version 2303 (16227.20318) (shows same values repeated)
I checked same file with a thrid computer MAC - with version 16.77.1 (23091703) and shows also values repeated).
Computer 1 is the only one that shows correctly only unique values in the drop down list
Thanks!
Álvaro
- HansVogelaarOct 06, 2023MVP
It looks like Microsoft quietly introduced this in Excel for Windows in the August 2023 update, together with the AutoComplete feature in data validation drop-downs. That's why it works in version 2309 but not in 2303. It'll probably be released for Mac pretty soon.