Excel2000: Data validation behaving funny
 

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)<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.laanemets<attarkon.ee )

Excel2000: Data validation behaving funny
 

Hi Arvi,

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

Andy.

"Arvi Laanemets" wrote in message
...
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)<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.laanemets<attarkon.ee )

Excel2000: Data validation behaving funny
 

Oops!

Thanks!
Arvi Laanemets


<Andy wrote in message ...
Hi Arvi,

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

Andy.

Excel2000: Data validation behaving funny
 

It's nice to be able to help you, for once, rather than the other way round!

Andy.

"Arvi Laanemets" wrote in message
...
Oops!

Thanks!
Arvi Laanemets


<Andy wrote in message ...
Hi Arvi,

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

Andy.

Excel2000: Data validation behaving funny
 

Strange that excel didn't/wouldn't kick up a formula error message.

Biff

<Andy wrote in message ...
It's nice to be able to help you, for once, rather than the other way
round!

Andy.

"Arvi Laanemets" wrote in message
...
Oops!

Thanks!
Arvi Laanemets


<Andy wrote in message ...
Hi Arvi,

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

Andy.