EXCEL IDENTIFYING SIMILAR INTEGERS

[ROBERT BROWN]

HI I AM HAVE A PROBLEM USING EXCEL. I HAVE OVER 50,000
NUMBERS IN ONE COLUMN. IS THERE A FUNCTION ON EXCEL THAT
WILL ALLOW ME TO SCAN THE NUMBERS AND HIGHLIGHT NUMBERS
THAT ARE THE SAME AS EACH OTHER. PLEASE HELP IF ANYONE
CAN AS IVE BEEN TRYING TO SOLVE THIS FOR 2 WEEKS. MY
EMAIL IS (e-mail address removed).

THANK YOU

 

[Frank Kabel]

Hi
first: please turn off your CAPS-lock: Difficult to read and considered
as SHOUTING in newsgroups

For your question: see
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[JE McGimpsey]

First - PLEASE turn your CAPS LOCK off. All Caps is much harder to read,
and is generally considered the equivalent of shouting in the newsgroups.

Take a look at

http://cpearson.com/excel/duplicat.htm