Forum Discussion
Excel Data Validation - recent change is 'auto' filtering duplicates.
I use Excel Data Validation lists to quickly select information. I use blank rows to space out options. Since today, these blank rows AND any list entry that is identical until the second paragraph i...
pretty sure this is part of the dynamic filter added to the drop down lists. The is a new feature that started rolling out way back then but only recently reached the rest of us. Basically you can now type in the box and it will autofilter the list to only those entries that match your typing. Apparently this is also filtering duplicates.
