| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
double data
how can i determine if i have a double data in whole column? is there a validation to prevent double data entry? tnx -- xtrmhyper ------------------------------------------------------------------------ xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851 View this thread: http://www.excelforum.com/showthread...hreadid=480979 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
double data
To use data validation to prevent duplicate entries in Column A, say Highlight the column and enter the following formula in the appropriat Data Validation box: =Countif(A:A,A1)=1 David -- david ----------------------------------------------------------------------- davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064 View this thread: http://www.excelforum.com/showthread.php?threadid=48097 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
double data
To use data validation to prevent duplicate entries in Column A, say Highlight the column and enter the following formula in the appropriat Data Validation box: =Countif(A:A,A1)=1 David -- david ----------------------------------------------------------------------- davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064 View this thread: http://www.excelforum.com/showthread.php?threadid=48097 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
double data
formula is working in typing data only but when i copy paste validation is not working is there another way? -- xtrmhyper ------------------------------------------------------------------------ xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851 View this thread: http://www.excelforum.com/showthread...hreadid=480979 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove double data? | Excel Worksheet Functions | |||
| How do I double the column data? | Excel Discussion (Misc queries) | |||
| double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
| Double Sorting of Data | Excel Discussion (Misc queries) | |||
| double data | Excel Programming | |||
![xtrmhyper[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
