|
PureBytes Links
Trading Reference Links
|
I recently switched PCs and, although I'm not using it at the moment, I
wanted to install TS2000i on my new machine. Whenever I attempt this
from my SP3 CD the setup program says it needs to install MDAC
components. It extracts these files from the CD then requests a shutdown
before re-starting the setup but after the restart the setup program
just goes round again saying it needs to install MDAC components. And so
it goes round and round in circles!
Any ideas?
Robert
-----Original Message-----
From: cwest [mailto:cwest@xxxxxxxxxxxx]
Sent: 26 June 2003 04:20
To: omegalist
Subject: Re: Excel question
Clearly I could have been clearer :-) Sorry. I hope this is better.
I wish to use the last value in a column as a divisor in a formula. I
have a
column of 900 cells. Not all of them always contain values, and the
values
change (given another event), although there aren't any nulls between
values. For example:
A1 value1
A2 value2
A3 null
A... null
A900 null
My formula is x/A2. How do I discover that A2 contains the last value in
the
column?
Another example:
A1 value1
A2 value2
A3 value3
A4 null
A... null
A900 null
How do I discover that A3 contains the last value in the column?
I looked at Kim's and Alex's suggestions, but couldn't get them to work.
Also couldn't find reference to some of the components in help.
Thanks
Colin
|