1000 limit on autofilter

[Jack Schitt]

I should be grateful for guidance on any "workarounds" to get around the
1000 limit on records that appear in dropdown lists in autofilter.

Thanks

 

[Debra Dalgleish]

You can use an additional column with a formula to break the items into
groups. There are a couple of examples here:

http://www.contextures.com/xlautofilter02.html#Limits

 

[Portuga]

If you have so much information why not use a Pivot Table to display th
data

 

[Jack Schitt]

Thanks that will work for me

You can use an additional column with a formula to break the items into
groups. There are a couple of examples here:

http://www.contextures.com/xlautofilter02.html#Limits