how to make number unique in Excel column?
I am entering a long list of ID numbers. Can I get Excel to reject ID if it
has already been used? |
Bob, you can use data validation to keep people from putting duplicate
numbers in a column, select column A, data, validation, custom, formula: = COUNTIF($A:$A,A1)<2 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Bob" wrote in message ... I am entering a long list of ID numbers. Can I get Excel to reject ID if it has already been used? |
Brilliant, many thanks Paul B. I owe you a drink.
Bob "Paul B" wrote: Bob, you can use data validation to keep people from putting duplicate numbers in a column, select column A, data, validation, custom, formula: = COUNTIF($A:$A,A1)<2 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Bob" wrote in message ... I am entering a long list of ID numbers. Can I get Excel to reject ID if it has already been used? |
All times are GMT +1. The time now is 07:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com