I AM WORKING WITH A LIST OF REFERNEC NUMBERS AND WANT TO STOP DUPLICATE ENTRIES
J JOHNNYG Dec 10, 2005 #1 I AM WORKING WITH A LIST OF REFERNEC NUMBERS AND WANT TO STOP DUPLICATE ENTRIES
D David McRitchie Dec 10, 2005 #2 Use cell validation, which you can read about or view at Validate / Validation http://www.mvps.org/dmcritchie/excel/validation.htm =COUNTIF(tablename,A1)=1 Data Validation lists, Debra Dalgleish, Contextures.com http://www.contextures.com/xlDataVal01.html a video presentation look for " - Data Validation in Excel" at http://www.datapigtechnologies.com/ExcelMain.htm
Use cell validation, which you can read about or view at Validate / Validation http://www.mvps.org/dmcritchie/excel/validation.htm =COUNTIF(tablename,A1)=1 Data Validation lists, Debra Dalgleish, Contextures.com http://www.contextures.com/xlDataVal01.html a video presentation look for " - Data Validation in Excel" at http://www.datapigtechnologies.com/ExcelMain.htm
