Max

Thanks once again for you patience with someone who knows enough to
know that Excel can do something but not quite enough to get it to do
it.

David


Max wrote:
"david" wrote:
I have uploaded the problem file to savefile.com
http://www.savefile.com/projects/674184

Here's the implemented file:
http://cjoint.com/?hej7AWtVYv
Incident_Book_for_playY9.xls

In sheet: Printout,

In A6, A6 copied across to K6, then filled down to K100:
=IF(ROW(A1)COUNT($O:$O),"",INDEX(Y9Incidents!A:A, MATCH(SMALL($O:$O,ROW(A1)),$O:$O,0)+8))

We need to adjust with a "+8" to the result returned by MATCH since the
source data in sheet: Y9Incidents begins in row 14 and the formula's starting
row here is row 6.

The criteria col O
In O6 filled down to say O100 (say):
=IF(OR(Control!$C$9="",Control!$C$10="",Control!$C $10=""),"",IF(Y9Incidents!B14="","",IF(AND(Y9Incid ents!B14=Control!$C$9,Y9Incidents!D14=Control!$C$ 10,Y9Incidents!D14<=Control!$C$11),ROW(),"")))
(Leave O1:O5 empty)

And for a neater look, we can suppress extraneous zeros in the sheet
via clicking: Tools Options View tab Uncheck Zero values OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---