Using IF and SUMPRODUCT??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Sorry. That does help. What happens is only blanks show up and I know there
are duplicates.
 
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)
 
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
 
Back
Top