F2?
--
Regards,
Peo Sjoblom
"One-Leg" wrote in message
...
And where do I put this???
"Biff" wrote:
Hi!
If I'm not clear enough
Well, I'll take a guess anyhow!
Entered with the key combo of CTRL,SHIFT,ENTER:
=MIN(IF(H:H<"X",G:G))
Biff
"One-Leg" wrote in message
...
I'll try to explain my situation...
I have a budget in Excel that goes until the end of 2006.
In one colum ("G"), I have the remaining balance of my bank account.
In
the
next colum ("H"), I put an X in the cells where the dates have allready
passed.
I would like to have, in cell "F2", the lowest amount of money I have
left
until the end of my budget.
If I'm not clear enough, please send my a private message and I'll send
you
an example of what I'm looking for...
Thanks!!!
|