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: 27
Default To filter for 100 documents out of 1000

Hi,
I have a long list of entries (about 1000) and out of these, I need to
filter out 100 selected documents. Right now i'm using advanced filter. But
in order to do this, I have to manually place all these documents diagonally
so as to do it as a OR condition, ie,

Document Document Document
11111111
22222222
33333333

It's very time consuming coz i have to manually pull down those document
numbers into different rows. Is there a faster way to do this?

Regards,
Val
 
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
How change maximal value in excel for filter (1000) ? Poul New Users to Excel 1 July 27th 06 04:03 PM
Excel Documents Don't Appear in My Recent Documents Addi Excel Discussion (Misc queries) 4 July 24th 05 09:43 PM
Why does excel not see more than 1000 lines in filter mode? Abdullah Kajee Excel Discussion (Misc queries) 7 December 13th 04 01:03 PM
Function Help Steven M. Britton Excel Worksheet Functions 0 December 9th 04 03:33 PM
Amortization Schedule Steven M. Britton Excel Worksheet Functions 0 December 8th 04 04:23 AM


All times are GMT +1. The time now is 12:10 AM.

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"