View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Subhashis Bhowmick Subhashis Bhowmick is offline
external usenet poster
 
Posts: 1
Default Restricted Range in Auto filter

Sir,

I have filtered some range in a sheet in Excel 2000, with a title. But it
take only 1000 records / rows in its filter range while searching, such as if
I had entered some 1500 different values it will show me the first 1000 value
in its range in assending order, and out of which if few records repete
values in range it includes in it. Can you tell me any way so that it can
take all the data of different range within range 1st row to 65536th row.

Thanks & Regards,

Subhashis Bhowmick
NAGPUR