Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
NO DUPLICATE ENTRIES IN A COLUMN USING EXCEL
I AM WORKING WITH A LIST OF REFERNEC NUMBERS AND WANT TO STOP DUPLICATE ENTRIES
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
NO DUPLICATE ENTRIES IN A COLUMN USING EXCEL
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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "JOHNNYG" wrote ...(translated to English) I am working with a list of reference numbers and want to stop duplicate entries |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
question for excel how to have linked sum in column? | Excel Discussion (Misc queries) | |||
How do I find duplicate entries in Excel | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How can I purge duplicate entries in Excel | Excel Discussion (Misc queries) |