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
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
...@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
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
@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
*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
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,
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
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
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
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
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
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
*
*
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
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
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/
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,
17 matches
Mail list logo