First, sorry for the repost but I wasn't sure if last weeks post was able to
be followed today.

I'm trying to create a formula that will look for multiple quotes from the
same vendor that have the same parts listed on them. If there are matching
quotes I want to say "Yes" in cell AZ of the older quote. The criteria I need
to match is vendor and part number then find the most current date of the
quote and put "Yes" in the older quote.

TIA
Joe

"Bob Phillips" wrote:

That doesn't check duplicates, it just checks which rows satisfy all 3
conditions. I can get a Yes with a single row, no duplicates there.

Explain the problem, what to check for duplication, etc.,someone will help
you.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joe Gieder" wrote in message
...
Sorry. That does help. What happens is only blanks show up and I know
there
are duplicates.

"Bob Phillips" wrote:

So are you just telling us, or saying it doesn't work? If the latter,
what
happens?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joe Gieder" wrote in message
...
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