We'd like to remind Forumites to please avoid political debate on the Forum. This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
We're aware that dates on the Forum are not currently showing correctly. Please bear with us while we get this fixed, and see Site feedback for updates.

Identifying duplicates in Excel

davetrousers
davetrousers Posts: 5,862 Forumite
Part of the Furniture 1,000 Posts Combo Breaker
edited 25 October 2010 am31 10:30AM in Techie Stuff
In Excel (2003) is there a way to identify/highlight duplicated records? Either by conditional format or formula.

What I would normally do is sort the column ascending then put in a formula in the adjacent column that says =if(A1=A2,1,0) etc. then look for the 1s. But there must be a better way of checking for duplicates mustn't there?

Thanks for your help
.....

Comments

  • I either do what you do or use =COUNTIF(A: A,A2)>1 and set it to highlight the cell a different colour when its a duplicate. Withouth the space otherwise you get a :A on here
    2020 Mortgage-Free Wannabes #20 £1495.03/£2760 OP
  • Thanks, that's better than my method.
    .....

This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 348.3K Banking & Borrowing
  • 252.1K Reduce Debt & Boost Income
  • 452.4K Spending & Discounts
  • 240.9K Work, Benefits & Business
  • 617.2K Mortgages, Homes & Bills
  • 175.7K Life & Family
  • 254.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 15.1K Coronavirus Support Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.