Re: Complicated Formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi. I'm using the first formula you wrote under "cell two". It's working but
its grabbing the number above the column, not the numbers below. Do you know
how I could fix this?

Example :

1,3,5,2,4,

It's taking the 5 then dividing by the 1, not dividing by the 2 (on the
other side).
Thanks!


"JulieD" wrote:

> Hi Stephen
>
> cell 1
> =MAX(A1:A10)
>
> cell 2
> =MAX(A1:A10)/MIN(OFFSET(A1:A10,0,0,MATCH(MAX(A1:A10),A1:A10,0)))
> or
> =A12/MIN(OFFSET(A1:A10,0,0,MATCH(A12,A1:A10,0)))
> where A12 holds the formula of "cell 1" above
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "Stephen" <Stephen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:CD6B1F82-B59F-405A-A4F7-D314B81EB887@xxxxxxxxxxxxxxxx
> > Hi. I'm trying to do a very complicated formula.
> > I have a list of ten numbers in a row and I have one cell which is telling
> > me the max of those ten numbers.
> > This new cell I want to be able to find the number that was returned from
> > the above cell and then create a formula from that point. I want the
> > formula
> > to keep looking back (going down the excel spread***) looking for the
> > lowest number in a row from that number, and divide the current number by
> > that number.
> >
> > Example:
> >
> > From say a1:a10 I have :
> > 2, 6, 4, 8, 4, 9, 3, 2, 1, 4
> >
> > Cell one returns - 9
> > Cell two would look what came before the 9 and find the lowest number in a
> > row and divide cell one's number by this lower number. So it would find 1
> > is
> > the lowest number in a row and divide 9/1, bringing you to the answer of
> > 9.
> > Thanks for you help!
> > --
> > Thanks!
> >
> > Stephen
>
>
>
.

Quantcast