|
Using IF and SUMPRODUCT??
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) "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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 12:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com