How to find repeated name in the list

  • Thread starter Thread starter Robert Tellis
  • Start date Start date
R

Robert Tellis

Am new

Could anyone help me I have a database of 5000 employees
name could you please let me know if i want to see any
employees names is repeated in the list How I can find
out.

Thanks
Franics
 
Hi

When you have employees names p.e. in column A, then activate cell A1 and
define a named range
ListToCheck=OFFSET(Sheet1!$A$1,,,ROW(Sheet1!$A1),1)

Now (with cell A1 selected) format cell A conditionally
(Format.ConditionalFormat):
Formla is:
=AND((ListToCheck=A1)*1>1,ListToCheck<>"")
and select some fill color for case contition returns true (p.e. red).
Copy cell A1, select range in column A1 you want to check, and paste format
(PasteSpecial.Format) to selected range.

Whenever you now enter some value into column A, when the same value is
entered above it, the cell(s) with duplicate value(s) is colored (into red,
p.e.) - only first occurence of value remains uncolored.
 
Back
Top