Prev: Can't open an excel file (have 2007, Vista) without saving fir
Next: Pivot table magic
From: sanjay on 30 May 2010 08:25
how to find duplicate entry in one sheet and in workbook
From: bala_vb on 30 May 2010 10:43

sanjay;957113 Wrote:
> 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




--
bala_vb
 | 
Pages: 1
Prev: Can't open an excel file (have 2007, Vista) without saving fir
Next: Pivot table magic