Sep 01 2020 07:46 AM
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 use the filter it will only filter the first 8 weeks.
Sep 01 2020 10:19 AM
How the filter is connected to data validation? Or you mean size of the drop-down list?
Sep 01 2020 11:10 AM
@Sergei Baklan 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.
Sep 01 2020 01:23 PM
As variant filtering could not be applied to entire range, whatever. Could you please submit sample file to illustrate the issue?
Sep 01 2020 01:54 PM
Hi @Sergei Baklan out of frustration and time I just deleted what I had and started over. Thanks for trying!