|
PureBytes Links
Trading Reference Links
|
Colin,
......your formula =MAX(COUNT(H3:H900)) will always return 898 if all the
rows are non-blank but so will =MIN(COUNT(A1:A10)) or just COUNT(A1:A10)
????
So, I may have misunderstood what you are trying to do but given the
following numbers in range A1:A10 ..
1
2
5
20
30
40
10
50
60
70
=MAX(COUNT(A1:A10)) will return '10' {as will =MAX(COUNT(A1:A10)) or
COUNT(A1:A10)} ????
If you mean you want the address of the cell which contains the value which
is equal to the result of the formula above (in this example a value of '10'
which is in cell A7), then the following will return $A$7
=CELL("address",INDEX(A:A,MATCH(COUNT(A1:A10),A1:A10,0)))
Rgds,
Kim
----- Original Message -----
From: "cwest" <cwest@xxxxxxxxxxxx>
To: "'Omegalist'" <omega-list@xxxxxxxxxx>
Sent: Wednesday, June 25, 2003 6: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
>
>
>
|