Forum Discussion
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...
What are the versions of Excel on the two computers?
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
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.