ExcelBanter - how to find duplicate entry in one sheet and in workbook

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

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

- - how to find duplicate entry in one sheet and in workbook (https://www.excelbanter.com/excel-discussion-misc-queries/264896-how-find-duplicate-entry-one-sheet-workbook.html)

Sanjay

how to find duplicate entry in one sheet and in workbook

how to find duplicate entry in one sheet and in workbook

bala_vb

Quote:

Originally Posted by sanjay (Post 957113)

how to find duplicate entry in one sheet and in workbook

use conditional formating to locate duplicate entry in sheet

copy this formula in conditional formating with red color for the entire worksheet.

=COUNTIF(A:XFD,A1)1

all the best

All times are GMT +1. The time now is 10:47 PM.