Hi Mahesh, One way is to select all cells in the column:
(I have assumed Col A, starting Row 2) Select conditional format, formula is, then enter: =COUNTIF($A$2:$A$1000, A2)>1 Set the format you want - say red bold text. Hit ok All duplicates will be red bold. Change the range and starting cell to suit your data. The attached shows this method in practice. As you add new values to Col A, they will be red bold if they are not unique. Hope this helps Regards - Dave. Date: Fri, 5 Jun 2009 09:38:23 +0530 Subject: $$Excel-Macros$$ Need Help!!!!!!!!!!!! From: mahender.bi...@gmail.com To: excel-macros@googlegroups.com Dear All, I want to know the how i can find the repeat or duplicate value in same column or row.(without Advance filter) -- With Love, Mahesh Bisht _________________________________________________________________ Get the latest news, goss and sport Make ninemsn your homepage! http://windowslive.ninemsn.com.au/article.aspx?id=813730 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Dups.xls
Description: MS-Excel spreadsheet
