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.

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.

"Lambchop" wrote:

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.

Hi

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

--
Regards
Roger Govier



"Lambchop" wrote in message
...
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.

"Lambchop" wrote:

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.

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.



"Roger Govier" wrote:

Hi

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

--
Regards
Roger Govier



"Lambchop" wrote in message
...
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.

"Lambchop" wrote:

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.

Maybe something like

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

entered with ctrl + shift & enter


--


Regards,


Peo Sjoblom



"Lambchop" wrote in message
...
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.



"Roger Govier" wrote:

Hi

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

--
Regards
Roger Govier



"Lambchop" wrote in message
...
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.

"Lambchop" wrote:

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.