Yours has a fair bit of overhead before it really gets going... Once it gets
going it may well be faster but you have to get past the advanced filter and
such first. I would suspect that on large datasets it might be faster.
--
HTH...

Jim Thomlinson


"Don Guillett" wrote:


Further testing with Jim's and mine actually shows Jim's to be a bit
quicker. I wonder why and also if the same would still be the case on a
large database???
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jim Thomlinson" wrote in message
...
If the question is important enough for you to request my immediate time
then
it should be important enough for you to devote your immediate time... If
you
don't have the time right now then don't request my time right now.

Just so we are all on the same page I do not know of anyone around here
who
witholds answering quesitons based on who is asking, but there are a few
people I recall who burned their bridges... oddly enough they never posted
again.

Jim Cone... only 1200. When did you start the list. Last month... <bg
--
HTH...

Jim Thomlinson


"ReportSmith" wrote:

Guys, guys, guys,
To clarify...I did not dismiss the posted solutions/suggestions. I have
multiple responsibilities and need to attend to other matters as well
(there
are only so many hours in a day). My reply was a quick one just so I
could
acknowledge the responders. So, just the opposite of what Jim said.

To continue my original thought...I will test out the suggested solutions
and compare the time differentials - and go with the one that makes most
sense and is quickest.

Once again, thanks for the solutions and suggestions (that will not go
ignored).

"Jim Cone" wrote:

Jim,
It seems to me that the more time spent on a solution the greater the
chance
that it will be ignored. <g
Maybe the complexity increases with the time spent and the answer
becomes unintelligible to the poster?

Lacking worthwhile pursuits, a while back, I started a list of posters
who do not
acknowledge responses. Just those posters whose questions I attempted
to
answer and the poster ignored all responses from me or others.

The list is up to about 1200 now.
--
Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jim Thomlinson"
wrote in message
What gets me is if you had to pay for the advice you would not dismiss
the
solution based on time constraints. Even more basic than that if you
had to
ask someone face to face for help you would not dismiss their help with
such
little regard...
Just my 2 cents...
--
HTH...
Jim Thomlinson



"Don Guillett" wrote:
Jim, This happens to all of us often.
I tested your solution and it does the same as mine.
I only felt that FIND would be a bit quicker on a large data field