| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validations in excel for particular column
In one of the column the same data should not be repeated while entering or
coping and should prompt or give a error message. OR How can i ensure that the same data is not repeated while entering or coping in a particular column? Pl help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validations in excel for particular column
One way, assuming data will be only* be entered manually down col A ..
*as any copy-pasting, or dragging down a cell with input in it will override the validation Select col A (click on the col header "A") Click Data Validation Allow: Custom Formula: =COUNTIF($A:$A,A1)<2 Click OK Test it out .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vijay Kotian" wrote: In one of the column the same data should not be repeated while entering or coping and should prompt or give a error message. OR How can i ensure that the same data is not repeated while entering or coping in a particular column? Pl help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validations in excel for particular column
1st line should read as:
One way, assuming data will only* be entered manually down col A .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validations in excel for particular column
Thank you for your reply. You have solved one problem but another is still
unresolved.... copy and pasting from other file if with any command can be restircted nothing like it.. "Max" wrote: One way, assuming data will be only* be entered manually down col A .. *as any copy-pasting, or dragging down a cell with input in it will override the validation Select col A (click on the col header "A") Click Data Validation Allow: Custom Formula: =COUNTIF($A:$A,A1)<2 Click OK Test it out .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vijay Kotian" wrote: In one of the column the same data should not be repeated while entering or coping and should prompt or give a error message. OR How can i ensure that the same data is not repeated while entering or coping in a particular column? Pl help. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validations in excel for particular column
Pl see my response to your new posting ..
(an example using worksheet code by Vasant) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vijay Kotian" wrote: Thank you for your reply. You have solved one problem but another is still unresolved.... copy and pasting from other file if with any command can be restricted nothing like it.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Linear Mode
