Tags: alert, duplicate, entry, excel, grateful, greetings, guys, happy, holiday, microsoft, msdn, software

Can Excel alert me to a duplicate entry?

On Microsoft » Microsoft Excel

2,934 words with 3 Comments; publish: Thu, 22 May 2008 20:39:00 GMT; (30662.50, « »)

First of all a happy happy Holiday greetings from a grateful reader here.

You guys are the best....I'm wondering if it is possible, if Excel can

notify me if I enter a duplicate number into a cell. I need to enter serial

numbers of inventory, and sometimes I get my sheets mixed up, and enter the

same info again. Can that be avoided'

All Comments

Leave a comment...

  • 3 Comments
    • Maybe...

      Chip Pearson has some techniques at:

      http://www.cpearson.com/excel/duplicat.htm

      PeterM wrote:

      > First of all a happy happy Holiday greetings from a grateful reader here.

      > You guys are the best....I'm wondering if it is possible, if Excel can

      > notify me if I enter a duplicate number into a cell. I need to enter serial

      > numbers of inventory, and sometimes I get my sheets mixed up, and enter the

      > same info again. Can that be avoided'

      --

      Dave Peterson

      #1; Thu, 22 May 2008 20:40:00 GMT
    • PeterM Wrote:

      > First of all a happy happy Holiday greetings from a grateful reader

      > here.

      > You guys are the best....I'm wondering if it is possible, if Excel

      > can

      > notify me if I enter a duplicate number into a cell. I need to enter

      > serial

      > numbers of inventory, and sometimes I get my sheets mixed up, and enter

      > the

      > same info again. Can that be avoided'

      You can do this to prevent duplicate entries in a column:

      1. Select a range where entries will be made (e.g., Cells A1:A500)

      2. Go to Data/Validation/Custom

      3. Enter this formula =countif($A$1:A500,A1)=1

      4. Select "Error Alert" tab and enter any appropriate message

      Regards.

      BenjieLop

      ---

      BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019

      View this thread: http://www.excelforum.com/showthread.php?threadid=494944

      #2; Thu, 22 May 2008 20:41:00 GMT
    • ...another way to do it would be conditional formatting. In the second cell

      from the top, go to "Format" then "Conditional Formatting". Change the drop

      down from "Cell is" to "Formula is" then type =A2=A1 and choose a format

      (highlight yellow or something). Then copy A2 and Paste Special...Formats

      as far down the page as you need to. You can then occasionally sort you

      serial numbers and duplicates will highlight yellow.

      "PeterM" wrote:

      > First of all a happy happy Holiday greetings from a grateful reader here.

      > You guys are the best....I'm wondering if it is possible, if Excel can

      > notify me if I enter a duplicate number into a cell. I need to enter serial

      > numbers of inventory, and sometimes I get my sheets mixed up, and enter the

      > same info again. Can that be avoided'

      >

      >

      #3; Thu, 22 May 2008 20:42:00 GMT