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 |