Thread: Lowest numbers
View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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!!!