AgTalk Home
AgTalk Home
Search Forums | Classifieds (113) | Skins | Language
You are logged in as a guest. ( logon | register )

Is there a way to check for duplicate #'s in excel?
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Omar
Posted 9/4/2010 16:55 (#1346549 - in reply to #1341784)
Subject: RE: Is there a way to check for duplicate #'s in excel?


Elmira, Ontario

Probably the simplest method is to use a Countif formula.

If your list of EID numbers are in column A, put the following in B1 (or other suitable spot) and copy it down. The dollar signs are important so the range you are looking at doesn't shift as you copy it down.

=COUNTIF($A$1:$A$15,A1)

This particular method will show a "1" for unique numbers, and each duplicate will show "2" or higher depending how many duplicates there are.

Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)