software

Hi

Yesterday I found, that custom data validation is behaving very strange. At
start I tested 2 workbooks with same type of data validation on 2 different
computers, than in a newly created workbook on my computer - with same
result.

I have a list of entries on sheet, and I need to restrict double entries in
a column. So I select a range (E1:E20), and apply custom data validation
rule
(COUNTIF($E:$E,$E1)lt;2)

1. Instead automatically being adjusted, in all cells the formula remains
same, i.e. it counts entries equal to E1, not to active cell.
2. Whatever I try to enter into any cell in range E1:E20, Excel restricts
the entry.Thanks in advance for any good advice!

--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
Hi Arvi,

Are you using
COUNTIF($E:$E,$E1)lt;2
or
=COUNTIF($E:$E,$E1)lt;2

Andy.

quot;Arvi Laanemetsquot; gt; wrote in message
...
gt; Hi
gt;
gt; Yesterday I found, that custom data validation is behaving very strange.
gt; At start I tested 2 workbooks with same type of data validation on 2
gt; different computers, than in a newly created workbook on my computer -
gt; with same result.
gt;
gt; I have a list of entries on sheet, and I need to restrict double entries
gt; in a column. So I select a range (E1:E20), and apply custom data
gt; validation rule
gt; (COUNTIF($E:$E,$E1)lt;2)
gt;
gt; 1. Instead automatically being adjusted, in all cells the formula remains
gt; same, i.e. it counts entries equal to E1, not to active cell.
gt; 2. Whatever I try to enter into any cell in range E1:E20, Excel restricts
gt; the entry.
gt;
gt;
gt; Thanks in advance for any good advice!
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt;
Oops!

Thanks!
Arvi Laanemetslt;Andygt; wrote in message ...
gt; Hi Arvi,
gt;
gt; Are you using
gt; COUNTIF($E:$E,$E1)lt;2
gt; or
gt; =COUNTIF($E:$E,$E1)lt;2
gt;
gt; Andy.
gt;
It's nice to be able to help you, for once, rather than the other way round!

Andy.

quot;Arvi Laanemetsquot; gt; wrote in message
...
gt; Oops!
gt;
gt; Thanks!
gt; Arvi Laanemets
gt;
gt;
gt; lt;Andygt; wrote in message ...
gt;gt; Hi Arvi,
gt;gt;
gt;gt; Are you using
gt;gt; COUNTIF($E:$E,$E1)lt;2
gt;gt; or
gt;gt; =COUNTIF($E:$E,$E1)lt;2
gt;gt;
gt;gt; Andy.
gt;gt;
gt;
gt;
Strange that excel didn't/wouldn't kick up a formula error message.

Biff

lt;Andygt; wrote in message ...
gt; It's nice to be able to help you, for once, rather than the other way
gt; round!
gt;
gt; Andy.
gt;
gt; quot;Arvi Laanemetsquot; gt; wrote in message
gt; ...
gt;gt; Oops!
gt;gt;
gt;gt; Thanks!
gt;gt; Arvi Laanemets
gt;gt;
gt;gt;
gt;gt; lt;Andygt; wrote in message ...
gt;gt;gt; Hi Arvi,
gt;gt;gt;
gt;gt;gt; Are you using
gt;gt;gt; COUNTIF($E:$E,$E1)lt;2
gt;gt;gt; or
gt;gt;gt; =COUNTIF($E:$E,$E1)lt;2
gt;gt;gt;
gt;gt;gt; Andy.
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;