"Array" problem?
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.
|