To filter for 100 documents out of 1000

D

Dolphinv4

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
 
R

Roger Govier

Hi Val

Since you are dealing with a single field, Document, then the list
required can all be entered one below each other in a single column.
This gives an OR function
Document
11111
22222
33333

Putting items adjacent gives an AND function
Document Document
11111 22222
which would be impossible for this field, because it cannot be both
11111 AND 22222 at the same time
but
Document Document
11111
22222
does give the equivalent of an OR because other entries on the same row
are blank

Document Document
=11111 <=22222
Click to expand...
would give all documents in the range between the 2 values.
 
Top