Help with function...

[Kemp]

I have a spreadsheet with about 2500 "records". Each row
is a record, and the first column is a date.

Another column may or may not contain a number 1, 2 or 3.
See below:

Column A Column B
8/5/04 2
8/8/04 1
8/11/04
8/13/04 1
8/15/04
8/17/04
8/21/04 1

I need to count back from the last entry in Column B until
the Sum = 3 (8/8/04 in the above example), reference the
corresponding date (again...8/8/04), and add 90 days to it.

Any suggestions?

Kemp Hiatt

 

[Frank Kabel]

Hi
try the following:
1. in column C enter the following formula in C1:
=IF(A1<>"",SUM($C$1:$C1),"")
and copy this down for all rows

2. Now use the following formula (entered as array formula with
CTRL+SHIFT+ENTER):
=INDEX($A$1:$A$2500,MATCH(TRUE,($B$1:$B$2500<=MAX(C:C)-3),0))+90