Using IF and SUMPRODUCT??

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
 
B

Bob Phillips

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)
 
G

Guest

Sorry. That does help. What happens is only blanks show up and I know there
are duplicates.
 
B

Bob Phillips

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)
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top