| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NO DUPLICATE VALUE IN THE COLUMN
To all
Hello, Please help me about this. I want a formula or validatation in 1 column that pop up a message if the data is already available or already used. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NO DUPLICATE VALUE IN THE COLUMN
See
http://cpearson.com/excel/NoDupEntry.htm In article , Paulex wrote: To all Hello, Please help me about this. I want a formula or validatation in 1 column that pop up a message if the data is already available or already used. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NO DUPLICATE VALUE IN THE COLUMN
Data Validation Setting tab Allow: Custom Formula: =COUNTIF(A:A,A1)=1
"Paulex" wrote: To all Hello, Please help me about this. I want a formula or validatation in 1 column that pop up a message if the data is already available or already used. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Duplicate Numbers In A Column: How ? | New Users to Excel | |||
| How to find the duplicate text from a column or from a row? | Excel Discussion (Misc queries) | |||
| what key do i use to duplicate column ? | Excel Worksheet Functions | |||
| can i not allow duplicate values in the same column? | New Users to Excel | |||
| Finding duplicate nuumbers in a column | Excel Worksheet Functions | |||
Hybrid Mode
