Maybe it would be better if you tried experimenting with
criteria/extract
just a suggestion

streetboarder Wrote:
Morrigan,
using the formula you provided would it be possible to change it a bit
to find the top 20 projects that are not started and pull this
information to the summary page?

Project Numbers 1-20 (z_data!$A15:A100)
Project Status = "Not Started" (z_data!$AD15:$AD100)

Summary Page = (Summary!A35)

I have been making a lot of progress with this report and can't thank
you enough.

Thanks!


--
FireWater
------------------------------------------------------------------------
FireWater's Profile: http://www.excelforum.com/member.php...o&userid=33846
View this thread: http://www.excelforum.com/showthread...hreadid=534553