Named Ranges Not Working in Data Validation
Sorry Pete this did not work.
"Pete_UK" wrote:
Try it with the sheet name in front of the named range, i.e.:
Sheet1!cells_EMPLNO
Hope this helps.
Pete
On Nov 22, 9:07 pm, dplum wrote:
I want to use a named range in the Custom Data Valiadtion dialog.
If the Formula = "=COUNTIF(cells_EMPLNO,A2)<=1" it does not work.
However, if the formula = "=COUNTIF($A$2:$A$28,A2)<=1" it works.
Is there any way to get the Named Range option to work?
|