Use CountIf function. see attached file for example. Any cells having value more than 1 in column B has a duplicate record on its left.
_________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." ________________________________ From: vinu <[EMAIL PROTECTED]> To: MS Excel & VBA Macros <excel-macros@googlegroups.com> Sent: Monday, 3 November, 2008 10:10:30 AM Subject: $$Excel-Macros$$ Re: How to findout Duplicate items Its working well... could you pls let me know is there any other way through forumula do the same function without using macro. On Nov 1, 4:43 am, [EMAIL PROTECTED] wrote: > Use below code. > > Sub DupFinder() > Dim r As Range, t As Range > Cells(1, ActiveCell.Column).Select > Range(Selection, Selection.End(xlDown)).Select > Set t = Selection > For Each r In t > v = r.Value > If Application.WorksheetFunction.CountIf(t, v) > 1 Then > r.Interior.ColorIndex = 3 > End If > Next > End Sub > > Select first cell of the column where you have your data and run the macro. > All the duplicates will turn red. > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > ________________________________ > From: vinod kumar kumar <[EMAIL PROTECTED]> > To: excel-macros@googlegroups.com > Sent: Friday, 31 October, 2008 5:50:41 PM > Subject: $$Excel-Macros$$ How to findout Duplicate items > > Hello All, > > Could you pls help me out in the below issue. > > I have 50 amounts in a single column, those are repeated amounts. > I would like to know which are all repeated amounts by highlighting or > something like that. > > Thanks > -- > Vinu > > (¨`*.*´¨) Always > `*.¸(¨`*.*´¨) Keep > (¨`*.*´¨)¸.*´ Smiling! > `*.¸.*´ > > Add more friends to your messenger and enjoy! Go > tohttp://messenger.yahoo.com/invite/ Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
Dup Finder.xls
Description: MS-Excel spreadsheet
