ExcelBanter - De-duplicating

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - De-duplicating (https://www.excelbanter.com/excel-discussion-misc-queries/38720-de-duplicating.html)

Peter

De-duplicating

What is the quickest way to highlight duplications in a long column of
numbers or text? Thanks.
--
Peter
London, UK

JE McGimpsey

Take a look at

http://cpearson.com/excel/duplicat.htm

In article ,
"Peter" wrote:

What is the quickest way to highlight duplications in a long column of
numbers or text? Thanks.

All times are GMT +1. The time now is 12:02 AM.