Increasing number of unique entries in the drop-down list
 

Dear friends,
I need more than 1000 unique entries in the drop down-list while using
Autofilter feature of Excel. But I have lists that contain lots of data. Is
there any way to increase unique entries? Thanks beforehand. Any help will be
appreciated.
Abas

Increasing number of unique entries in the drop-down list
 

Try Debra's workarounds at her page:
http://www.contextures.com/xlautofilter02.html#Limits
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Abas Ibrahimov" wrote:
Dear friends,
I need more than 1000 unique entries in the drop down-list while using
Autofilter feature of Excel. But I have lists that contain lots of data. Is
there any way to increase unique entries? Thanks beforehand. Any help will be
appreciated.
Abas

Increasing number of unique entries in the drop-down list
 

http://www.contextures.com/xlautofilter02.html
--
David Biddulph

"Abas Ibrahimov" wrote in message
...
Dear friends,
I need more than 1000 unique entries in the drop down-list while using
Autofilter feature of Excel. But I have lists that contain lots of data.
Is
there any way to increase unique entries? Thanks beforehand. Any help will
be
appreciated.
Abas