How to find repeated name in the list

[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

 

[Norman Harker]

Hi Robert!

See:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm

 

[Arvi Laanemets]

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.