View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Mark Mark is offline
external usenet poster
 
Posts: 102
Default How can I avoid duplications entering data in Excel?

On Dec 27, 10:34*am, JCHSAlgebraTeacher
wrote:
*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


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.