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...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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?
- 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
AlvaroWhat are the versions of Excel on the two computers?
