Hi there,
basically I have a load of data and I want to remove the duplicates. what I have done is concatenated the data into one cell which are all in column E.so what I want is a code that goes down column E and any time it hits a duplicate I want it to colour the cell red. i would be grateful if somone could help me on the code.
Why not use the built in function with Excel 2007?
Home tab >> Styles >> Conditional Formatting >> Highlight Cells Rules >> Duplicate Values
HTH
Regards, Jeff
could u upload a sample file,which contains data similar to that.
Hi
In Conditional Formatting rules(Range(E1:?), put this formula and choose red color.
=COUNTIF($D:$D,$D1)>1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I know how to do it in excel but I really what to do it in vba as It's for a project I have been doing at work and I've been using vba for it.
When you say remove the duplicates, do you want to remove them completely or leave one instance of the duplicate?
Last edited by jeffreybrown; 07-20-2012 at 02:30 PM. Reason: spelling
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks