If column value is greater than x paste row into sheet x?

[bunkum]

Hi I have a report of specific patients, and the time before they have had a verified report.
I'd like to paste the complete row, of any row where the value in column I is an integer greater than 96 (not blank, or NA), into the new worksheet, so that only the episodes that have not received a report for more than 96 hours appear and can be followed up.


Is this possible?


I'm a total noob when it comes to this array stuff, and I'd appreciate any help on this one.


Thanks :-)

[Fotis1991]

In A2 of your new sheet put this ARRAY(see my signature) formula.

=INDEX('KPI_Radiologist Report Times By'!A$5:A$3000,SMALL(IF(('KPI_Radiologist Report Times By'!$I$5:$I$3000>96)*('KPI_Radiologist Report Times By'!$I$5:$I$3000<>"NA"),ROW('KPI_Radiologist Report Times By'!A$5:A$3000)-4),ROW('KPI_Radiologist Report Times By'!A1)))

Copy down as you want and across to column M.

[bunkum]

Wow thanks Fotis, that was perfect, and such a quick reply!!
Much appreciated :-)