Or (slaps head) --
Just use: =countifs($B$2:$B$1000,$B2,$C$2:$C$1000,$C2)=1 Asa From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Tuesday, October 04, 2011 9:40 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Hi Chil, I didn't realize you were looking for a pair of cells matching to determine duplicates when I suggested the data validation rule using countif. You can modify that data validation rule using a sumproduct formula that will search for that pair of data. This validation rule works for me: =SUMPRODUCT(($B$2:$B$1000=$B2)*($C$2:$C$1000=$C2))=1 Apply this formula with the other info in my first post and I think you'll be set. Sumproduct works because it takes as arguments one or more arrays, and can be used as an alternative way to specify an array formula like this one. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Tuesday, October 04, 2011 6:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Thanks Rajan I need is to columns B and C (together) containing the mirrored pair in same row good solution you propose, but only in column B duplicate Thanks Rajan 2011/10/4 rajan verma <rajanverma1...@gmail.com> Try this Code : this Code enable you to check the duplicate entry at the time of Data Entry .. Private Sub Worksheet_Change(ByVal Target As Range) Dim lngValue As Long Dim intICounter As Integer Dim strMsg As String lngValue = Target.Value If Intersect(Target, Range("B:B")) Then For intICounter = 1 To Target.Row - 1 If Range("B" & intICounter).Value = lngValue Then strMsg = strMsg & "Row" & intICounter & vbCrLf Next intICounter End If If strMsg <> "" Then strMsg = "Duplicate Record of " & Target.Value & vbCrLf & vbCrLf & strMsg MsgBox strMsg End If End Sub On Mon, Oct 3, 2011 at 10:15 PM, ChilExcel <chilexcel...@gmail.com> wrote: hi i Need VB lines codes for Alert MsgBox Pair duplicate entry in row Column D function account and duplicates alerts (NO Problem!) Attach File , thank you all -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 <tel:%2B91%209158998701> -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
