Dear Paul, I know vba editor and handling..please provide me an advice..for this request.. Kind regards, Lax
On Thursday, October 30, 2014 6:03:44 PM UTC+5:30, Laxmanan M wrote: > Dear Paul, > > Yes you are right..You got the point..as im new to this type of > formula's..Either it may be a formula or vba...Can you please help to > complete this ..Am trying here..but i could not get the click to apply the > formula as am knowing little in the vba and formula sections.. > > Kind Regards, > Lax > > > > > On Thursday, October 30, 2014 5:55:20 PM UTC+5:30, Paul Schreiner wrote: > >> OK, so basically, if I went through the list and: >> a) Combine the ID and Name >> b) If this combination is "new", add it to a list of unique records >> c) if this combination already exists, mark the CURRENT and PREVIOUS >> record of this combination as "FAILED" >> >> What do you want to do with the "FAILED" designation? >> put it in column "A"? >> >> you could also do this with a "helper" column. >> >> Say, in cell "I2" put the formula: =G2&H2 >> Then, in cell "J2" put: =IF(COUNTIF(I:I,I2)>1,"FAILED","OK") >> and copy these two formulas down. >> >> We could do something similar with VBA. >> Create a Dictionary Object (array) to store the ID/Name combinations. >> If the combo exists, mark each record as "Failed", otherwise, add the >> unique combo. >> >> *Paul* >> ----------------------------------------- >> >> >> >> >> >> >> >> *“Do all the good you can,By all the means you can,In all the ways you >> can,In all the places you can,At all the times you can,To all the people >> you can,As long as ever you can.” - John Wesley* >> ----------------------------------------- >> >> *From:* Laxmanan M <laxfly...@gmail.com> >> *To:* excel-...@googlegroups.com >> *Cc:* schrein...@att.net >> *Sent:* Thursday, October 30, 2014 7:54 AM >> *Subject:* Re: $$Excel-Macros$$ Load data's Update using vba >> >> Dear paul, >> >> Here is the answer.Please help me on the same.. >> >> *Adding additional information:* >> >> so basically we should check the column H first. >> For instance if you found 3 similar match of "1ST MILESTONE LTD", >> then first you should check if it has id in the column G, if not then >> "FAILED", >> if there is Id, then you should check further if the corresponding >> records in the column G crosschecked with column D contains unique records >> only. >> >> For example: >> >> >> ZM01,396085586,1ST DEFENSE LTD >> ZM07,396085586,1ST DEFENSE LTD >> ZM11,396085586,1ST DEFENSE LTD >> >> These 3 rows above should be "FAILED", because ZM01,07,11 have the same >> ID. >> >> ZM01,396085586,1ST DEFENSE LTD >> ZM07,396085587,1ST DEFENSE LTD >> ZM11,396085588,1ST DEFENSE LTD >> >> >> These 3 rows above should be "OK", because ZM01,07,11 have different IDs >> >> >> I hope I could manage to explain it clearly. >> >> >> Thanks, >> Lax >> >> >> >> >> >> >> >> On Wednesday, October 29, 2014 9:36:03 PM UTC+5:30, Paul Schreiner wrote: >> >> Your description is somewhat confusing. >> Are you saying that you want the combination of columns D,G,H to be >> unique? >> >> For instance, rows 24,25,26 have >> Vendor Group: ZM01 >> Credit Check Information Number 552654477 and >> Name1: ABDELHADI - INTELLECTUAL PROPERTY >> >> Does that mean that rows 24,25,26 should have "Failed" in some column? >> or only in row 25,26? >> or some other test or result? >> >> and: >> "check if the vendor names are the same or not" >> The same as what? >> check to see if you have duplicate names? >> or?? >> >> *Paul* >> ------------------------------ ----------- >> >> >> >> >> >> >> >> *“Do all the good you can,By all the means you can,In all the ways you >> can,In all the places you can,At all the times you can,To all the people >> you can,As long as ever you can.” - John >> Wesley*------------------------------ >> ----------- >> >> *From:* Laxmanan M <laxfly...@gmail.com> >> *To:* excel-...@googlegroups.com >> *Sent:* Wednesday, October 29, 2014 10:31 AM >> *Subject:* $$Excel-Macros$$ Load data's Update using vba >> >> Hi There, >> Good evening all, >> Like i have been allocated to work on the below item..i tried but am >> failing..below is my requirement. >> So there are two things i have to do using vba macros.. >> 1) the vendors (rows) in this sheet should be checked by the following >> condition: >> vendors with ZM01, ZM07, ZM11 account group (column D) should not have >> the same DUSN number (column G). You can use column H for the vendor >> comparision. Unfortunately at this point we don't have unique ids :( If it >> has then make all the rows for that vendor "FAILED" >> 2) this is the harder one. We should check if the vendor names are the >> same or not. If not, then "FAILED" >> Any help appreciated >> >> >> Attaching the file for referncce >> lax >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@ googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> >> >> -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
