Results 1 to 4 of 4

To prevent duplicate entries using Data validation.

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    18

    To prevent duplicate entries using Data validation.

    -------------------------------
    Hi,

    I juz wanna prevent the duplicate entries in a range using the data validation. I know , we can use the "custom list" in data validation and use the formula =countif(range,criteria)=1 to prevent the duplicates. But My problem is typical..In the selected range, i will use the text "NA" and some numbers. So i juz want the numerics to be prevented in the data validation. If i use the above countif formul, it also prevents the word "NA". But i need "NA" to be allowed and to prevent only the numbers.

    Can anyone help me out?-------------------------------------------------
    Last edited by legendkiller420; 07-09-2010 at 07:40 AM. Reason: Notification

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1