PC Review


Reply
Thread Tools Rate Thread

How do I keep duplicate text from being entered in an excel file?

 
 
Ed Green
Guest
Posts: n/a
 
      4th Jan 2010
I am entering product names in excel (in the hundreds) and I would like to
have excel check that as I enter a name it has not already been used.
 
Reply With Quote
 
 
 
 
Per Jessen
Guest
Posts: n/a
 
      4th Jan 2010
Hi

Select the column with product names, and goto Data > Validation > Allow:
Custom > Formula: =CountIf($A:$A,A1)=1

Hopes this helps
...
Per



"Ed Green" <Ed (E-Mail Removed)> skrev i meddelelsen
news:509170E8-C641-435F-9DAC-(E-Mail Removed)...
>I am entering product names in excel (in the hundreds) and I would like to
> have excel check that as I enter a name it has not already been used.


 
Reply With Quote
 
Jim Thomlinson
Guest
Posts: n/a
 
      4th Jan 2010
You can use data validation with a custom formula. To restict the entries in
Column A

Select Column A
Select Data -> Validation | Custom
Add this formula
=COUNTIF(A:A, A1) = 1
Select Ok

Column A should now be restricted to unique entries.
--
HTH...

Jim Thomlinson


"Ed Green" wrote:

> I am entering product names in excel (in the hundreds) and I would like to
> have excel check that as I enter a name it has not already been used.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Open excel file when file name is entered in cell K Microsoft Excel Programming 4 17th Mar 2009 12:12 AM
Duplicate the contents of a row when text is entered in a cell Shonzi Microsoft Excel Misc 10 14th Apr 2007 04:13 AM
How Excel can tell me i have entered a duplicate number =?Utf-8?B?QXV0b2ZpbGw=?= Microsoft Excel Misc 2 12th Jul 2006 12:08 PM
Excel will not show all text entered in a Cell merged from 9 rows =?Utf-8?B?UGF0?= Microsoft Excel Misc 6 18th Aug 2005 11:14 PM
Re: In excel how can i give text entered into a cell a numerical valu. JulieD Microsoft Excel Misc 0 15th Sep 2004 03:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:18 AM.