If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I avoid duplications entering data in Excel?
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
How can I avoid duplications entering data in Excel?
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 |
Thread Tools | |
Display Modes | |
|
|