LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bdq17
 
Posts: n/a
Default Duplicate Data

How do I get excel to automatically detect and notify when I've typed the
same number in two cells of the same column? I get a lot of duplicate product
numbers that I imput into column A of my spreadsheet. Example: If I type the
number 123456 into A1 I don't want that number in any other cell of column A
and I want excel to notify me if I type a duplicate.
 
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
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Another question on how to find duplicate data Eroc Excel Worksheet Functions 2 December 14th 04 05:03 AM
Finding duplicate data Eric Stoakes Excel Worksheet Functions 3 December 9th 04 04:33 PM


All times are GMT +1. The time now is 01:46 AM.

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

About Us

"It's about Microsoft Excel"