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
Posts: 5,862 Forumite


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
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
.....
0
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 here2020 Mortgage-Free Wannabes #20 £1495.03/£2760 OP0
-
Thanks, that's better than my method......0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

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