Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricting cells to unique values
I'm entering invoice identification numbers and want to format the column so
that if a duplicate number is entered by mistake it will be flagged as an error. I'm using Excel 2002. Thank you in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricting cells to unique values
Maybe you could use conditional formatting. If your inputs are A1:A10 select
A1:A10, Format/Conditional formatting Formula Is: =COUNTIF(A$1:A1,A1)1 and select a cell or font format. "Todd" wrote: I'm entering invoice identification numbers and want to format the column so that if a duplicate number is entered by mistake it will be flagged as an error. I'm using Excel 2002. Thank you in advance for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricting cells to unique values
Hi Todd,
1) select the first cell in the column, say cell B1 for column B 2) use menu item Data - Validation 3) set Validation criteria to Custom 4) enter =COUNTIF(B:B,B1)<=1 in the formula box 5) click OK 6) copy cell B1 to all of column B (just click on the column B heading to select the whole column) Now you can only enter unique valueds in column B. You can revisit Data - Validation to provide more meaningful error messages if you wish. Ed Ferrero www.edferrero.com I'm entering invoice identification numbers and want to format the column so that if a duplicate number is entered by mistake it will be flagged as an error. I'm using Excel 2002. Thank you in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
Summing unique values | Excel Worksheet Functions | |||
cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |