ExcelBanter - Finding duplicate data in a worksheet

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

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

- - Finding duplicate data in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/64666-finding-duplicate-data-worksheet.html)

JTTJ

Finding duplicate data in a worksheet

What is the formula for finding duplicate data in a worksheet?

Norman Jones

Finding duplicate data in a worksheet

Hi JTTJ,

What is the formula for finding duplicate data in a worksheet?

See Chip Pearson's duplicates pages for a variety of techniques:

http://www.cpearson.com/excel/duplic...tingDuplicates

---
Regards,
Norman

All times are GMT +1. The time now is 09:44 AM.