Re: $$Excel-Macros$$ Excel - Array Help

> *Sent:* 21 January 2012 21:51 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Excel - Array Help > > ** ** > > Dear Amit, > > > In this formula we are searching unique value of two columns > Red Color part is 1st criteria

Re: $$Excel-Macros$$ Excel - Array Help

Hey Amit, > >look for SUMPRODUCT formula information and you will get your answer. >  >From: Amit Desai (MERU) >Sent: Saturday, January 28, 2012 2:43 AM >To: excel-macros@googlegroups.com >Subject: RE: $$Excel-Macros$$ Excel - Array Help >  Thanks Noorain, >   &g

Re: $$Excel-Macros$$ Excel - Array Help

tt1 wrote: > Did you copy down the formula? > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Amit Desai (MERU) > *Sent:* Saturday, January 28, 2012 2:43 AM > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$

Re: $$Excel-Macros$$ Excel - Array Help

Did you copy down the formula? Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Saturday, January 28, 2012 2:43 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel - Array Help Thanks Noorain, I have just seen your email... I

RE: $$Excel-Macros$$ Excel - Array Help

Of NOORAIN ANSARI Sent: 21 January 2012 21:51 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Amit, In this formula we are searching unique value of two columns Red Color part is 1st criteria Green Color part is 2nd Criteria =IF(SUMPRODUCT(($A$2:$A2=A2)*($

Re: $$Excel-Macros$$ Excel - Array Help

mp; I mean what >> logic it will follow. >> >> ** ** >> >> Regards,**** >> >> *Amit Desai* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSAR

Re: $$Excel-Macros$$ Excel - Array Help

glegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* 20 January 2012 16:22 > *To:* excel-macros@googlegroups.com > > *Subject:* Re: $$Excel-Macros$$ Excel - Array Help > > ** ** > > Dear Sourabh, > > > Please use this

RE: $$Excel-Macros$$ Excel - Array Help

.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Sourabh, Please use this one to find unique value of more than one column without using helping column =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,"Duplicate","Unique") See attached sheet. On Fri, Jan 20, 2012 a

Re: $$Excel-Macros$$ Excel - Array Help

Dear Sourabh, Please use this one to find unique value of more than one column without using helping column *=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,"Duplicate","Unique") * See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra wrote: > Thank you so much sir, if we want with

Re: $$Excel-Macros$$ Excel - Array Help

and plz explain the sum formula of counting unique records On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra wrote: > Thank you so much sir, if we want without help. col > > > On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI > wrote: > >> Dear Sourabh, >> >> Please see attached sheet. >> >> >> -

Re: $$Excel-Macros$$ Excel - Array Help

Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Please see attached sheet. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorai

Re: $$Excel-Macros$$ Excel - Array Help

Dear Sourabh, Please see attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra wrote: > * >

Re: $$Excel-Macros$$ Excel - Array Help

* * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI wrote: > Dear Amar, > > Please use below formula to count total unique name > *=SUM(1/COUNTIF(B2:B6,B2:B6)) > *press ctrl+Shift+Enter > > or use this one to

Re: $$Excel-Macros$$ Excel - Array Help

Hi Noorain, Thank you for the code, I think I'm getting some clue for my code, I'll try and let you know, thanks again. Best regards, Amar On 19/01/2012, NOORAIN ANSARI wrote: > Dear Amar, > > Please try it.. > > Sub Find_Duplicate_Entry() > Dim cel As Variant > Dim myrng As Range > Set myrng =

Re: $$Excel-Macros$$ Excel - Array Help

Dear Amar, Please try it.. Sub Find_Duplicate_Entry() Dim cel As Variant Dim myrng As Range Set myrng = Range("C2:C" & Range("C65536").End(xlUp).Row) myrng.Interior.ColorIndex = xlNone For Each cel In myrng clr = 10 If Application.WorksheetFunction.CountIf(myrng, cel) > 1 Then cel.Interior.ColorI

Re: $$Excel-Macros$$ Excel - Array Help

Hi Noorain, Thank you for these formulaes. but I'm actually using VBA macro's to do a task it'll be really great if you could let me know in VBA. Here is my current code, I don't know I'm not able to highlight the duplicates. Sub Test1() For J1 = 10 To 500 If Cells(J1, 1).Value = "XYZ"

Re: $$Excel-Macros$$ Excel - Array Help

Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)>1,"Duplicate","Unique") * see attached sheet.. -- Thanks & regards, Noorain Ansari

$$Excel-Macros$$ Excel - Array Help

Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the