Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I stop DBASE fns stopping on a subset of criteria?

0 views
Skip to first unread message

Bill Manville

unread,
Feb 23, 2000, 3:00:00 AM2/23/00
to
In article <38ABA950...@rmit.edu.au>, Nigel P.A. Thomas wrote:
> I have tried putting ="Mary" in the criteria, but this does not seem to
> make any diffce.
>
Try
="=Mary"

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup


Dr. Nigel P.A. Thomas

unread,
Feb 23, 2000, 3:00:00 AM2/23/00
to Bill-M...@msn.com
Very many thanks. I wasted hours on that one.
Nigel Thomas

Myrna Larson

unread,
Feb 24, 2000, 3:00:00 AM2/24/00
to
On Wed, 23 Feb 2000 14:58:26 +1100, "Dr. Nigel P.A. Thomas"
<nig...@rmit.edu.au> wrote:

> I wasted hours on that one.

Just a comment: This formula is documented in Help. If you search for Help on
"advanced filter", one of the topics is "types of comparison criteria". This
one is included. Maybe there are some others there that will save you time in
the future...


Nigel P.A. Thomas

unread,
Feb 25, 2000, 3:00:00 AM2/25/00
to Myrna Larson

Myrna Larson wrote:

> On Wed, 23 Feb 2000 14:58:26 +1100, "Dr. Nigel P.A. Thomas"
> <nig...@rmit.edu.au> wrote:
>

> > Thanks a lot. I wasted hours on that one. (This to Bill Manville)


>
> Just a comment: This formula is documented in Help. If you search for Help on
> "advanced filter", one of the topics is "types of comparison criteria". This
> one is included. Maybe there are some others there that will save you time in
> the future...

Myrna, you are correct in that the solution does actually exist in the HELP
file. The time I wasted was often in the HELP file. However it isn't in the
place you mentioned (which would be logical), but you have to look under
"Criteria", and then select the option button "Types of comparison criteria".
And you have to know this, because there are a great deal of paths that do not
land up at this point. It was a vague memory frm last year that took me within a
character of teh solution, but it took Bill Manville to tweek it correct.
Personally I find (generally) that the Help file is better than a textbook, but
things are not always stored in a logical order, nor are there always links which
are clear. Perhaps if MicroSoft were to get a syntactical expert to work the
system over so that people could find things over several logical paths ....
Regards,
Nigel Thomas


Myrna Larson

unread,
Feb 25, 2000, 3:00:00 AM2/25/00
to
On Fri, 25 Feb 2000 14:18:16 +1100, "Nigel P.A. Thomas" <nig...@rmit.edu.au>
wrote:

>Myrna, you are correct in that the solution does actually exist in the HELP


>file. The time I wasted was often in the HELP file. However it isn't in the
>place you mentioned (which would be logical), but you have to look under
>"Criteria", and then select the option button "Types of comparison criteria".

It is in that place in XL2000. If you are using an earlier version, you may
not find it there.

0 new messages