How can I avoid duplications entering data in Excel?

  • Thread starter Thread starter JCHSAlgebraTeacher
  • Start date Start date
J

JCHSAlgebraTeacher

I am entering names of students that I have had over the past 30 years from
rosters I have kept onto Excel. While I am entering the names (in 2 columns)
how can I have the computer notify me that I have entered a name already
entered since I do have some students more than once?

Version 2003
 
 I am entering names of students that I have had over the past 30 yearsfrom
rosters I have kept onto Excel.  While I am entering the names (in 2 columns)
how can I have the computer notify me that I have entered a name already
entered since I do have some students more than once?

Version 2003
Click to expand...

if you have no blank entries in your name columns, except for the ones
at the bottom of course, you may be able to use Excel's
Data...Filter...Auto Filter Option. It will give you the ability to
see if you have any duplicates very easily.
 
Hi

One way
In cell C1 enter the following formula
=IF(A1="","",COUNTIF($A$1:A1,A1))
and copy down as far as required
You will see a Count of the number of entries with that name in column C

--
Regards
Roger Govier

JCHSAlgebraTeacher said:
I am entering names of students that I have had over the past 30 years
from
rosters I have kept onto Excel. While I am entering the names (in 2
columns)
how can I have the computer notify me that I have entered a name already
entered since I do have some students more than once?

Version 2003

__________ Information from ESET Smart Security, version of virus
signature database 4733 (20091231) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4733 (20091231) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top