Auto Filter Range
You can get round the limitation in a variety of ways. For example,
using a Custom filter and if your values are numeric you can choose
Greater than some number, or if the values are text then you could
choose Begins with and then enter letters.
Hope this helps.
Pete
On Jun 19, 11:16 am, Subhashis Bhowmick
wrote:
Sir,
After specifying some range in a worksheet, only 1000 similar records appear
in the autofilter, How I can see more than 1000 records in a filter.
Regards,
Subhashis Bhowmick
Nagpur
|