software

I've always had problems with Excel 2002 crashing when I use the formula
auditing tool, evaluate formula, on really quot;complexquot; array formulas.

I'm sad to say Excel has hit a new low and even crashes on a simple formula
like this:

=IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)

It crashes evaluating the array:

A2:A$10gt;0

I pretty much have learned what formulas will cause a crash and don't use
the evaluate formula command on those formulas but this latest one is a joke
(but I'm not $%^*($%% laughing).

Yes, I know I can highlight expressions and press F9 but it's not the same
as evaluate formula. Evaluate formula is a great tool when it doesn't cause
a crash!

Rant over.

Biff
I just tried this in xl2003.

xl2003 didn't crash, but tools|formula auditing|evaluate formula didn't work
either.

The evaluation box just cleared when it was evaluating a2:a$10gt;0.
Biff wrote:
gt;
gt; I've always had problems with Excel 2002 crashing when I use the formula
gt; auditing tool, evaluate formula, on really quot;complexquot; array formulas.
gt;
gt; I'm sad to say Excel has hit a new low and even crashes on a simple formula
gt; like this:
gt;
gt; =IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)
gt;
gt; It crashes evaluating the array:
gt;
gt; A2:A$10gt;0
gt;
gt; I pretty much have learned what formulas will cause a crash and don't use
gt; the evaluate formula command on those formulas but this latest one is a joke
gt; (but I'm not $%^*($%% laughing).
gt;
gt; Yes, I know I can highlight expressions and press F9 but it's not the same
gt; as evaluate formula. Evaluate formula is a great tool when it doesn't cause
gt; a crash!
gt;
gt; Rant over.
gt;
gt; Biff

--

Dave Peterson

Oops. Never mind that last post. xl2003 crashed too.

(I didn't have anything in A1 and the formula evaluated to quot;quot; in my other test
(doh!!).)
Biff wrote:
gt;
gt; I've always had problems with Excel 2002 crashing when I use the formula
gt; auditing tool, evaluate formula, on really quot;complexquot; array formulas.
gt;
gt; I'm sad to say Excel has hit a new low and even crashes on a simple formula
gt; like this:
gt;
gt; =IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)
gt;
gt; It crashes evaluating the array:
gt;
gt; A2:A$10gt;0
gt;
gt; I pretty much have learned what formulas will cause a crash and don't use
gt; the evaluate formula command on those formulas but this latest one is a joke
gt; (but I'm not $%^*($%% laughing).
gt;
gt; Yes, I know I can highlight expressions and press F9 but it's not the same
gt; as evaluate formula. Evaluate formula is a great tool when it doesn't cause
gt; a crash!
gt;
gt; Rant over.
gt;
gt; Biff

--

Dave Peterson

Hi Dave!

This is very frustrating. I would just like to know whether it is in fact a
problem with Excel or maybe my machine configuration isn't up to the task.
(enough ram?) I have 256mb. That isn't a lot by *TODAYS* standard but that
was pretty strong when I got the machine and I've had this problem since day
1.

I'm getting tired of sending error reports to M$. It'd be nice to get some
feedback from them.

Biff

quot;Dave Petersonquot; gt; wrote in message
...
gt; Oops. Never mind that last post. xl2003 crashed too.
gt;
gt; (I didn't have anything in A1 and the formula evaluated to quot;quot; in my other
gt; test
gt; (doh!!).)
gt;
gt;
gt;
gt; Biff wrote:
gt;gt;
gt;gt; I've always had problems with Excel 2002 crashing when I use the formula
gt;gt; auditing tool, evaluate formula, on really quot;complexquot; array formulas.
gt;gt;
gt;gt; I'm sad to say Excel has hit a new low and even crashes on a simple
gt;gt; formula
gt;gt; like this:
gt;gt;
gt;gt; =IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)
gt;gt;
gt;gt; It crashes evaluating the array:
gt;gt;
gt;gt; A2:A$10gt;0
gt;gt;
gt;gt; I pretty much have learned what formulas will cause a crash and don't use
gt;gt; the evaluate formula command on those formulas but this latest one is a
gt;gt; joke
gt;gt; (but I'm not $%^*($%% laughing).
gt;gt;
gt;gt; Yes, I know I can highlight expressions and press F9 but it's not the
gt;gt; same
gt;gt; as evaluate formula. Evaluate formula is a great tool when it doesn't
gt;gt; cause
gt;gt; a crash!
gt;gt;
gt;gt; Rant over.
gt;gt;
gt;gt; Biff
gt;
gt; --
gt;
gt; Dave Peterson
Hi Biff

No consolation I know, but it's not your machine.
I have 1 GB RAM and just tested with XL2002 and XL2003 and experienced
the same crash.
I did wonder though, why you were using an array formula as opposed to
=IF(A1gt;0,(COUNTIF(A2:A$10,quot;gt;0quot;)-1)*A1,quot;quot;)
which produced the expected results for me in both versions.

--
Regards

Roger Govierquot;Biffquot; gt; wrote in message
...
gt; Hi Dave!
gt;
gt; This is very frustrating. I would just like to know whether it is in
gt; fact a problem with Excel or maybe my machine configuration isn't up
gt; to the task. (enough ram?) I have 256mb. That isn't a lot by *TODAYS*
gt; standard but that was pretty strong when I got the machine and I've
gt; had this problem since day 1.
gt;
gt; I'm getting tired of sending error reports to M$. It'd be nice to get
gt; some feedback from them.
gt;
gt; Biff
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt;gt; Oops. Never mind that last post. xl2003 crashed too.
gt;gt;
gt;gt; (I didn't have anything in A1 and the formula evaluated to quot;quot; in my
gt;gt; other test
gt;gt; (doh!!).)
gt;gt;
gt;gt;
gt;gt;
gt;gt; Biff wrote:
gt;gt;gt;
gt;gt;gt; I've always had problems with Excel 2002 crashing when I use the
gt;gt;gt; formula
gt;gt;gt; auditing tool, evaluate formula, on really quot;complexquot; array formulas.
gt;gt;gt;
gt;gt;gt; I'm sad to say Excel has hit a new low and even crashes on a simple
gt;gt;gt; formula
gt;gt;gt; like this:
gt;gt;gt;
gt;gt;gt; =IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)
gt;gt;gt;
gt;gt;gt; It crashes evaluating the array:
gt;gt;gt;
gt;gt;gt; A2:A$10gt;0
gt;gt;gt;
gt;gt;gt; I pretty much have learned what formulas will cause a crash and
gt;gt;gt; don't use
gt;gt;gt; the evaluate formula command on those formulas but this latest one
gt;gt;gt; is a joke
gt;gt;gt; (but I'm not $%^*($%% laughing).
gt;gt;gt;
gt;gt;gt; Yes, I know I can highlight expressions and press F9 but it's not
gt;gt;gt; the same
gt;gt;gt; as evaluate formula. Evaluate formula is a great tool when it
gt;gt;gt; doesn't cause
gt;gt;gt; a crash!
gt;gt;gt;
gt;gt;gt; Rant over.
gt;gt;gt;
gt;gt;gt; Biff
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Dave Peterson
gt;
gt;
I have 1GB of memory and xl still crashed. It sure doesn't look like a hardware
problem to me.
Biff wrote:
gt;
gt; Hi Dave!
gt;
gt; This is very frustrating. I would just like to know whether it is in fact a
gt; problem with Excel or maybe my machine configuration isn't up to the task.
gt; (enough ram?) I have 256mb. That isn't a lot by *TODAYS* standard but that
gt; was pretty strong when I got the machine and I've had this problem since day
gt; 1.
gt;
gt; I'm getting tired of sending error reports to M$. It'd be nice to get some
gt; feedback from them.
gt;
gt; Biff
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; Oops. Never mind that last post. xl2003 crashed too.
gt; gt;
gt; gt; (I didn't have anything in A1 and the formula evaluated to quot;quot; in my other
gt; gt; test
gt; gt; (doh!!).)
gt; gt;
gt; gt;
gt; gt;
gt; gt; Biff wrote:
gt; gt;gt;
gt; gt;gt; I've always had problems with Excel 2002 crashing when I use the formula
gt; gt;gt; auditing tool, evaluate formula, on really quot;complexquot; array formulas.
gt; gt;gt;
gt; gt;gt; I'm sad to say Excel has hit a new low and even crashes on a simple
gt; gt;gt; formula
gt; gt;gt; like this:
gt; gt;gt;
gt; gt;gt; =IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)
gt; gt;gt;
gt; gt;gt; It crashes evaluating the array:
gt; gt;gt;
gt; gt;gt; A2:A$10gt;0
gt; gt;gt;
gt; gt;gt; I pretty much have learned what formulas will cause a crash and don't use
gt; gt;gt; the evaluate formula command on those formulas but this latest one is a
gt; gt;gt; joke
gt; gt;gt; (but I'm not $%^*($%% laughing).
gt; gt;gt;
gt; gt;gt; Yes, I know I can highlight expressions and press F9 but it's not the
gt; gt;gt; same
gt; gt;gt; as evaluate formula. Evaluate formula is a great tool when it doesn't
gt; gt;gt; cause
gt; gt;gt; a crash!
gt; gt;gt;
gt; gt;gt; Rant over.
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson

Hi Roger!

gt; I did wonder though, why you were using an array formula as opposed to
gt; =IF(A1gt;0,(COUNTIF(A2:A$10,quot;gt;0quot;)-1)*A1,quot;quot;)

I'm looking for the first position of a value that is gt;0. Countif would
count how many meet that criteria in the entire range.

Biff

quot;Roger Govierquot; gt; wrote in message
...
gt; Hi Biff
gt;
gt; No consolation I know, but it's not your machine.
gt; I have 1 GB RAM and just tested with XL2002 and XL2003 and experienced the
gt; same crash.
gt; I did wonder though, why you were using an array formula as opposed to
gt; =IF(A1gt;0,(COUNTIF(A2:A$10,quot;gt;0quot;)-1)*A1,quot;quot;)
gt; which produced the expected results for me in both versions.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi Dave!
gt;gt;
gt;gt; This is very frustrating. I would just like to know whether it is in fact
gt;gt; a problem with Excel or maybe my machine configuration isn't up to the
gt;gt; task. (enough ram?) I have 256mb. That isn't a lot by *TODAYS* standard
gt;gt; but that was pretty strong when I got the machine and I've had this
gt;gt; problem since day 1.
gt;gt;
gt;gt; I'm getting tired of sending error reports to M$. It'd be nice to get
gt;gt; some feedback from them.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Oops. Never mind that last post. xl2003 crashed too.
gt;gt;gt;
gt;gt;gt; (I didn't have anything in A1 and the formula evaluated to quot;quot; in my
gt;gt;gt; other test
gt;gt;gt; (doh!!).)
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; Biff wrote:
gt;gt;gt;gt;
gt;gt;gt;gt; I've always had problems with Excel 2002 crashing when I use the
gt;gt;gt;gt; formula
gt;gt;gt;gt; auditing tool, evaluate formula, on really quot;complexquot; array formulas.
gt;gt;gt;gt;
gt;gt;gt;gt; I'm sad to say Excel has hit a new low and even crashes on a simple
gt;gt;gt;gt; formula
gt;gt;gt;gt; like this:
gt;gt;gt;gt;
gt;gt;gt;gt; =IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)
gt;gt;gt;gt;
gt;gt;gt;gt; It crashes evaluating the array:
gt;gt;gt;gt;
gt;gt;gt;gt; A2:A$10gt;0
gt;gt;gt;gt;
gt;gt;gt;gt; I pretty much have learned what formulas will cause a crash and don't
gt;gt;gt;gt; use
gt;gt;gt;gt; the evaluate formula command on those formulas but this latest one is a
gt;gt;gt;gt; joke
gt;gt;gt;gt; (but I'm not $%^*($%% laughing).
gt;gt;gt;gt;
gt;gt;gt;gt; Yes, I know I can highlight expressions and press F9 but it's not the
gt;gt;gt;gt; same
gt;gt;gt;gt; as evaluate formula. Evaluate formula is a great tool when it doesn't
gt;gt;gt;gt; cause
gt;gt;gt;gt; a crash!
gt;gt;gt;gt;
gt;gt;gt;gt; Rant over.
gt;gt;gt;gt;
gt;gt;gt;gt; Biff
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt;
gt;gt;gt; Dave Peterson
gt;gt;
gt;gt;
gt;
gt;
Hi Biff

Quite right, Countif provides totally the wrong answer.
However, on retrying your formula in XL2003, with data of 2,0,0,
,0,6,7,8,9,8 in cell a1:a10, I now get the correct result of 8 returned
to the formula posted in cell C1, whereas previously I was getting #
VALUE.
On trying to Evaluate the formula with Auditing, I still experience the
crash.
Very peculiar.

--
Regards

Roger Govierquot;Biffquot; gt; wrote in message
...
gt; Hi Roger!
gt;
gt;gt; I did wonder though, why you were using an array formula as opposed
gt;gt; to
gt;gt; =IF(A1gt;0,(COUNTIF(A2:A$10,quot;gt;0quot;)-1)*A1,quot;quot;)
gt;
gt; I'm looking for the first position of a value that is gt;0. Countif
gt; would count how many meet that criteria in the entire range.
gt;
gt; Biff
gt;
gt; quot;Roger Govierquot; gt; wrote in message
gt; ...
gt;gt; Hi Biff
gt;gt;
gt;gt; No consolation I know, but it's not your machine.
gt;gt; I have 1 GB RAM and just tested with XL2002 and XL2003 and
gt;gt; experienced the same crash.
gt;gt; I did wonder though, why you were using an array formula as opposed
gt;gt; to
gt;gt; =IF(A1gt;0,(COUNTIF(A2:A$10,quot;gt;0quot;)-1)*A1,quot;quot;)
gt;gt; which produced the expected results for me in both versions.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Biffquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hi Dave!
gt;gt;gt;
gt;gt;gt; This is very frustrating. I would just like to know whether it is in
gt;gt;gt; fact a problem with Excel or maybe my machine configuration isn't up
gt;gt;gt; to the task. (enough ram?) I have 256mb. That isn't a lot by
gt;gt;gt; *TODAYS* standard but that was pretty strong when I got the machine
gt;gt;gt; and I've had this problem since day 1.
gt;gt;gt;
gt;gt;gt; I'm getting tired of sending error reports to M$. It'd be nice to
gt;gt;gt; get some feedback from them.
gt;gt;gt;
gt;gt;gt; Biff
gt;gt;gt;
gt;gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Oops. Never mind that last post. xl2003 crashed too.
gt;gt;gt;gt;
gt;gt;gt;gt; (I didn't have anything in A1 and the formula evaluated to quot;quot; in my
gt;gt;gt;gt; other test
gt;gt;gt;gt; (doh!!).)
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; Biff wrote:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; I've always had problems with Excel 2002 crashing when I use the
gt;gt;gt;gt;gt; formula
gt;gt;gt;gt;gt; auditing tool, evaluate formula, on really quot;complexquot; array
gt;gt;gt;gt;gt; formulas.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; I'm sad to say Excel has hit a new low and even crashes on a
gt;gt;gt;gt;gt; simple formula
gt;gt;gt;gt;gt; like this:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; =IF(A1gt;0,(MATCH(TRUE,A2:A$10gt;0,0)-1)*A1,quot;quot;)
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; It crashes evaluating the array:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; A2:A$10gt;0
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; I pretty much have learned what formulas will cause a crash and
gt;gt;gt;gt;gt; don't use
gt;gt;gt;gt;gt; the evaluate formula command on those formulas but this latest one
gt;gt;gt;gt;gt; is a joke
gt;gt;gt;gt;gt; (but I'm not $%^*($%% laughing).
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Yes, I know I can highlight expressions and press F9 but it's not
gt;gt;gt;gt;gt; the same
gt;gt;gt;gt;gt; as evaluate formula. Evaluate formula is a great tool when it
gt;gt;gt;gt;gt; doesn't cause
gt;gt;gt;gt;gt; a crash!
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Rant over.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Biff
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt;
gt;gt;gt;gt; Dave Peterson
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;