Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Hi all
Using the following formula in data validation will avoid the user entering duplicate entries, however, I don't understand what the A1 is for.... can anybody explain to me? Thank you. =countif($1:$65536,A1)<2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
It just says that whatever is entered in A1 cannot appear in the area more
than one time. -- Gary''s Student - gsnu200801 "Louise" wrote: Hi all Using the following formula in data validation will avoid the user entering duplicate entries, however, I don't understand what the A1 is for.... can anybody explain to me? Thank you. =countif($1:$65536,A1)<2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
but by highlighting the whole worksheet to begin with, the rule has been
applied to every cell any way, not just A1. Does that make sense?? Thanks, Louise. "Gary''s Student" wrote: It just says that whatever is entered in A1 cannot appear in the area more than one time. -- Gary''s Student - gsnu200801 "Louise" wrote: Hi all Using the following formula in data validation will avoid the user entering duplicate entries, however, I don't understand what the A1 is for.... can anybody explain to me? Thank you. =countif($1:$65536,A1)<2 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
You can apply the validation to only a single cell, but reference other cells
in the sheet. -- Gary''s Student - gsnu200801 "Louise" wrote: but by highlighting the whole worksheet to begin with, the rule has been applied to every cell any way, not just A1. Does that make sense?? Thanks, Louise. "Gary''s Student" wrote: It just says that whatever is entered in A1 cannot appear in the area more than one time. -- Gary''s Student - gsnu200801 "Louise" wrote: Hi all Using the following formula in data validation will avoid the user entering duplicate entries, however, I don't understand what the A1 is for.... can anybody explain to me? Thank you. =countif($1:$65536,A1)<2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |