Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 27th 09, 05:34 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 1
Default 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   Report Post  
Old December 28th 09, 07:59 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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.
  #3   Report Post  
Old January 1st 10, 10:46 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default 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



  #4   Report Post  
Old January 5th 21, 08:11 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 27
Default How can I avoid duplications entering data in Excel?

Select the range of cells in which you want to prevent duplicate values.
Choose Validation from the Data menu. In Excel 2007, click the Data tab and choose Data Validation from the Data Validation option's drop-down list (in the Data Tools group).
Click the Settings tab.
Choose Custom from the Allow drop-down list.
Enter a formula in the following form into the Formula control:=COUNTIF($range,firstcellinrange) = 1
Click the Error Alert tab.
Enter the text Duplicate Entry in the Title control.
In the Error Message box, enter a meaningful description, such as The value is a duplicate value and therefore, not valid.
Click OK.

I hope this is helpful!
Tim Paine


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Avoid re-entering 'Find what:' Gav Excel Discussion (Misc queries) 2 November 19th 07 06:37 PM
Checking for data duplications Nikki Excel Discussion (Misc queries) 1 March 2nd 06 05:07 PM
How can I generate random numbers but avoid duplications? specialk4life Excel Discussion (Misc queries) 1 December 5th 05 06:42 PM
Excel - highlight new data (by date ?) and avoid 'Save As' Tom Excel Discussion (Misc queries) 0 October 17th 05 08:49 PM
How do I check for duplications in a range of data (excel)? -Adrianna_ Excel Worksheet Functions 2 November 24th 04 11:25 AM


All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017