Morning all,

Could somebody advise me if the following is possible?

I work with GB Postcodes (zip codes) and a number of them are sent to me via a spreadsheet for me to use.

I would like to create a macro which highlights the duplicate codes (via conditional formatting) and then deletes the duplicate if possible.

Thanks
Steve

SAMPLE DATA
M27 0AW
M27 0EJ
M27 0HD
M27 0HD
M27 0HD
M27 4DQ
M27 4FT
M27 4HR
M27 4JH
M27 4JQ
M27 4JQ
M27 4TL
M27 4UB
M27 5DA
M27 5EG
M27 5LN
M27 5PT
M27 5PX
M27 5QG
M27 5SE
M27 5TA
M27 5TH
M27 5TH
M27 6BS
M27 6FS
M27 6WL
M27 8AE
M27 8AL
M27 8RS
M27 8RS
M27 8TD
M27 9PE
M27 9QS
M27 9RG
M27 9TB
M27 9UT
M27 9UT
M30 0FU
M30 0FX
M30 0GA
M30 0GS
M30 0HB
M30 0HB
M30 0HB
M30 0JA
M30 0JJ
M30 0JJ
M30 0JJ
M30 0JW
M30 0NF
M30 7AN
M30 7BY
M30 7HG
M30 7HH
M30 7HL
M30 7HR
M30 7LF
M30 7LF
M30 7LF
M30 7PA
M30 7PQ
M30 7PT
M30 8JD
M30 8JU
M30 8NH
M30 8NP
M30 8NP
M30 8PR
M30 9BU
M30 9DH
M30 9EW


M30 9GW
M30 9HU
M30 9HU
M30 9JA
M30 9JA
M30 9JA
M30 9LT
M30 9LT
M30 9PF
M30 9QD
M44 5BQ
M44 5FW
M44 5GB
M44 5GB
M44 5GJ
M44 5HN
M44 5HN
M44 5HN
M44 5JH
M44 5UA
M44 5UA
M44 5YG
M44 6AH
M44 6AN
M44 6FU
M44 6HQ
M44 6HX
M44 6RB
M44 6RF
M44 6RJ

Hi and welcome
you can easily highlight duplicate values with CF (something like =$A1=Countif($a$1:$a$100)>1
and remove duplicates using
Data - Remove duplicates (eventually recording a macro)
BTA what is the use of highlighting?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post