On Sun, 16 Oct 2005 15:13:02 -0700, "pdberger"
wrote:

I would like to compare a ratio of two numbers to ratios of other numbers in
the same columns, without doing the computations all the way along. That is:

A B
1 1 2
2 1 3
3 2 5

I would like to compare 2/5 against 1/2 and 1/3, but really want to avoid
creating a column (even a hidden one) to do the division each time. I want
to create automatically a chart showing the highest ratio, the lowest ratio,
and then the latest, most current one.

Thanks in advance for any help you can offer.


Max = =SUM((MAX((A1:A3)/(B1:B3))))
Min = =SUM((MIN((A1:A3)/(B1:B3))))
Current, assuming that's the last row, i.e. row 3 in this case
= INDIRECT("A"&COUNT(A1:A3))/INDIRECT("B"&COUNT(A1:A3))


Then have the chart refer to these three cells.

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________