Quote:
Originally Posted by sanjay
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