Not sure, but if you meant you wanted this "date": 9/8/09 (from your sample
data), ie the maximum row down where the amount is 10k
then this expression in say, C1, array-entered, ie press CTRL+SHIFT+ENTER to
confirm the formula:
=INDEX(A1:A9,MATCH(MAX(IF(B1:B910000,(ROW(A1:A9)) )),IF(B1:B910000,(ROW(A1:A9)),0)))
will extract it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Carl S." wrote:
Given:
01/05/09 $5,000
02/08/09 $12,000
03/06/09 $0
04/08/09 $13,000
5/13/09 $40,000
6/12/09 $2,000
8/5/09 $15,000
9/8/09 $63,000
10/09/09 $1,000
In example above, I need formula to find most recent date when dollar amount
greater than $10,000 became available. So, I need formula to select date
8/5/09 in above example. $12,000 on 2/8/09 was first incidence, 4/8/09 was
2nd incidence and 8/5/09 is last incidence, which is what is needed. Thanks
for any help given!