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

2012-01-28 Thread Amit Desai (MERU)
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)*($B$2

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

2012-01-28 Thread dguillett1
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

2012-01-28 Thread Sam Mathai Chacko
...@gmail.com wrote: Did you copy down the formula? Don Guillett SalesAid Software dguille...@gmail.com *From:* Amit Desai (MERU) amit.de...@merucabs.com *Sent:* Saturday, January 28, 2012 2:43 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Excel - Array Help

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

2012-01-28 Thread hanumant shinde
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,   I have just seen your email...   I

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

2012-01-24 Thread Kasireddy Amarender
@googlegroups.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

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

2012-01-21 Thread NOORAIN ANSARI
*To:* excel-macros@googlegroups.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

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

2012-01-20 Thread NOORAIN ANSARI
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 rhtdmja...@gmail.comwrote: Thank you so much sir,

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

2012-01-20 Thread Amit Desai (MERU)
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 at 6:50 AM, Sourabh Salgotra rhtdmja

$$Excel-Macros$$ Excel - Array Help

2012-01-19 Thread Kasireddy Amarender
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

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

2012-01-19 Thread NOORAIN ANSARI
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

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

2012-01-19 Thread Kasireddy Amarender
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

2012-01-19 Thread NOORAIN ANSARI
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.ColorIndex

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

2012-01-19 Thread Kasireddy Amarender
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 noorain.ans...@gmail.com wrote: Dear Amar, Please try it.. Sub Find_Duplicate_Entry() Dim cel As Variant Dim myrng As

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

2012-01-19 Thread Sourabh Salgotra
* * 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 noorain.ans...@gmail.comwrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or

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

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

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

2012-01-19 Thread Sourabh Salgotra
Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

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

2012-01-19 Thread Sourabh Salgotra
and plz explain the sum formula of counting unique records On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sourabh,