Thread: Index Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
 
Posts: 89
Default Index Question

I have a (I hope) simple question regarding the INDEX function. I have a
spreadsheet that calculates a mortgage schedule similar to this(some columns
have been deleted to get it into this space):

No. Payment Date Ending Balance
1 9/1/2008 $78,196.73
2 10/1/2008 78,122.08
3 11/1/2008 78,047.04
4 12/1/2008 77,971.60
5 1/1/2009 77,895.78
6 2/1/2009 77,819.56
7 3/1/2009 77,742.94
8 4/1/2009 77,665.92
etc.

I would like to find the payment number (column A) where the ending balance
is <=0

Any help would be appreciated.

Thanks

Iriemon