If you need to filter 65536 rows you are using the wrong program, Access
would be much better.



--
Regards,

Peo Sjoblom


"Subhashis Bhowmick" <Subhashis wrote in
message ...
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