First, Thank you for your help and all the help you have given.
I have this formula:
=IF(SUMPRODUCT(--($I$3:$I$4999=$I1766),--($AG$3:$AG$4999=$AG1766),--($AM$3:$AM$4999>$AM1766)),"Yes","")
Briefly I = part numbers, AG = suppliers and AM = quote date
What I'm trying to do is have the formula check the worksheet for duplicate
suppliers (AG) that have quoted the same part number (I) on different dates
(AM) and leave the results cell AZ blank for the match that's the most
current or does not match and put in "Yes" for the older matches.

TIA
Joe