| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
avoid retype the number more than one time withen acolumn
How can I avoid retyping the number more than one time withen acolumn.
I need a message "This no. already exist" to appear when I enter the same number twice. Thanks |
|
#2
|
|||
|
|||
|
Hi This,
How can I avoid retyping the number more than one time withen acolumn. I need a message "This no. already exist" to appear when I enter the same number twice. Let's say you're in cel A1. - Select the entire column by clicking the column letter. - Choose Data, Validation from the menu. - Click the dropdown next to "Allow" and select Custom. - Type this formula in the box next to "Formula": =COUNTIF(A1:$A$1,A1)=1 - Enter an error message and a prompt if you like and hit OK. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
| Number of employees in the appropriate time column | Excel Worksheet Functions | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Can excel automatically number itself each time you open a documen | Excel Discussion (Misc queries) | |||
Linear Mode
