Look up question

[Lambchop]

I have a row of numbers that represent cash. I use the min function to find
the lowest amount my cash gets to which is a negative and the Hlookup to find
the corresponding date. Now I need to find the first time my cash gets
positive that is equal to or greater than my min number. I tried using the
lookup function but it gives the amount that is less than the min. If you
can help me with this I would appreciate it.

 

[Lambchop]

let me make a small note to this post. If my min is ($500,000) I wan tto
find the first time the cash reaches $500,000 to the good.

 

[Roger Govier]

Hi

I'm not sure I have understood your request, but maybe something like
=MATCH(ABS(MIN(A1:M1)),A1:M1,0)

 

[Lambchop]

Roger.

Not exactly. Maybe this will help

a b c d e f g
h
(125) (525) (300) 0 25 225 575 625

The min is -525 and I want the formula to find the first time the Positive
number is => the min. I would need it to return the result of 575.
If you can help with this I would appreciate it.

 

[Peo Sjoblom]

Maybe something like

=INDEX(A1:H1,MATCH(TRUE,A1:H1>=ABS(MIN(A1:H1)),0))

entered with ctrl + shift & enter


--


Regards,


Peo Sjoblom