|
PureBytes Links
Trading Reference Links
|
Please elaborate on what you are trying to do. Here's my interpretation of
what you have given us: First you are counting the numbers in cells H3 to
H900. Call this 'N'. Then you are asking for the maximum of a list of
numbers, but the only number in your list is N, so of course N is the result
of the Max function. Then you are trying to discover the cell location
where this result, N, is true. Using Excel's definition of true, N will be
true when it is non-zero. So you are asking for the cell where N is
non-zero. I don't think this is what you mean. Please try to explain
better.
----- Original Message -----
From: "cwest" <cwest@xxxxxxxxxxxx>
To: "'Omegalist'" <omega-list@xxxxxxxxxx>
Sent: Wednesday, June 25, 2003 5:13 PM
Subject: Excel question
> I'm trying to insert a cell location into a formula. Can't seem to work
> it out.
>
> I need to discover the cell location in which this is true:
> =MAX(COUNT(H3:H900)). And then use the value in that location as a
> divisor. Any ideas?
>
> Thanks in advance
> Colin West
>
>
>
>
|