| 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 |
| 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) | |||
Threaded Mode
