Forum Discussion
JoHooverFGCUedu
Sep 01, 2020Copper Contributor
Excel Data Validation
Excel - Data Validation - I have a spreadsheet that I have created - I created the data validation ( Freshmen, Sophomore, Junior, Senior, Transfer, Blank or Week 1 - Week 17) but when I attempt to us...
SergeiBaklan
Sep 01, 2020Diamond Contributor
How the filter is connected to data validation? Or you mean size of the drop-down list?
JoHooverFGCUedu
Sep 01, 2020Copper Contributor
SergeiBaklan The size appears to be fine as it allowed me to choose all the correct drop downs. The filer is just through the filter tab which has its own drop down. When clicking on that drop down it provides the correct groups to filter. However, when it process it only filters correctly 8 rows and then the remaining rows are as if the filter stopped.
- SergeiBaklanSep 01, 2020Diamond Contributor
As variant filtering could not be applied to entire range, whatever. Could you please submit sample file to illustrate the issue?
- JoHooverFGCUeduSep 01, 2020Copper Contributor
Hi SergeiBaklan out of frustration and time I just deleted what I had and started over. Thanks for trying!