Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Validations in for 1 cell
I am using the validation tool to verfy data entry. I want to make sure that I am not letting the user enter duplicate data and have entered a custom validation rule of =COUNTIF($A$3:$A$1000,A15)=1 I would aslo like to limit the data entry to no more than 10 characters. How do I make this happen? I am not a programmer and do not know any vb code. Debbie -- dmcnutt_ghg ------------------------------------------------------------------------ dmcnutt_ghg's Profile: http://www.excelforum.com/member.php...o&userid=29044 View this thread: http://www.excelforum.com/showthread...hreadid=487748 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Validations in for 1 cell
Use a DV formula of
=AND(COUNTIF($A$3:$A$1000,A15)=1,LEN(A15)<=10) no need for VBA -- HTH RP (remove nothere from the email address if mailing direct) "dmcnutt_ghg" wrote in message ... I am using the validation tool to verfy data entry. I want to make sure that I am not letting the user enter duplicate data and have entered a custom validation rule of =COUNTIF($A$3:$A$1000,A15)=1 I would aslo like to limit the data entry to no more than 10 characters. How do I make this happen? I am not a programmer and do not know any vb code. Debbie -- dmcnutt_ghg ------------------------------------------------------------------------ dmcnutt_ghg's Profile: http://www.excelforum.com/member.php...o&userid=29044 View this thread: http://www.excelforum.com/showthread...hreadid=487748 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple cell editing | Excel Worksheet Functions | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
generate multiple rows based on cell value | Excel Worksheet Functions | |||
Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
Multiple lines in 1 cell | Excel Discussion (Misc queries) |