| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change maximal value in excel for filter (1000) ? | New Users to Excel | |||
| Excel Documents Don't Appear in My Recent Documents | Excel Discussion (Misc queries) | |||
| Why does excel not see more than 1000 lines in filter mode? | Excel Discussion (Misc queries) | |||
| Function Help | Excel Worksheet Functions | |||
| Amortization Schedule | Excel Worksheet Functions | |||
Threaded Mode
