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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com