View Single Post
  #1   Report Post  
pdberger
 
Posts: n/a
Default "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.