Did you create a test data list on Sheet2, and copy the formula I posted to
B1 of Sheet3, and enter a Proj. ID number in A1 of Sheet3, that you *know*
exists *more then once* in your test data list?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Erik Sauceda via OfficeKB.com" wrote in message
...
RadDyer,

Can you explain a bit more on your suggesstion? I am trying it out but I
don't understand the process.

Thanks

--
Message posted via http://www.officekb.com