LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Number the Rows of Auto Filter Result ashish128 Excel Discussion (Misc queries) 3 April 29th 07 06:41 PM
Separate Button for Auto Filter Selected Range Nasir Naqvi New Users to Excel 2 December 6th 06 03:15 PM
Range limit for auto filter function Pierre Excel Discussion (Misc queries) 3 June 30th 06 09:33 AM
Excel auto filter doesn't recoginize case - won't filter AA from A Mikey Excel Discussion (Misc queries) 1 September 29th 05 08:18 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"