To filter for 100 documents out of 1000
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
would give all documents in the range between the 2 values.
--
Regards
Roger Govier
"Dolphinv4" wrote in message
...
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
|