Forum Discussion
Question of Data Validation
Hi, I am using Data Validation conditional to another cell content, using "Indirect" function: a drop-list will appear on cell B3 conditioned to the text selected on A3. Once a selection is made, i...
Thanks. I have another question 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 only unique values out of that list (that is what I want), but if I do the same - same file - in another computer, I get a drop-list with duplicated values (many lines with same text). Do you know what the reason would be? Thanks Alvaro
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?
