Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |