Forum Discussion

Alvarom1's avatar
Alvarom1
Copper Contributor
Oct 06, 2023

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...
Excel
Alvarom1's avatar
Alvarom1
Copper Contributor

HansVogelaar 

here you have 2 pictures. I am doing exactly the same on both computers

Thanks

Alvaro

HansVogelaar's avatar
HansVogelaar
MVP
Oct 06, 2023

Alvarom1 

If you select the cell with the drop-down, then click Data Validation on the Data tab of the ribbon, what is the Source on the first computer, and what is the Source on the second computer?

  • Alvarom1's avatar
    Alvarom1
    Copper Contributor
    Oct 06, 2023
    Hi,
    it is the same complete list in both computers.
    I assume that it has to do something with the excel version, as I send the same file from one computer to another, and it behaves differently
    Thanks
    Alvaro
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 06, 2023

      Alvarom1 

      What are the versions of Excel on the two computers?

      • Alvarom1's avatar
        Alvarom1
        Copper Contributor
        Oct 06, 2023
        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

Resources