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" wrote in
message ...
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
__________ Information from ESET Smart Security, version of virus signature database 4733 (20091231) __________
The message was checked by ESET Smart Security.
http://www.eset.com