make two range exclusive
 

Hi all,

I have two range H100:M100 and H101:M101 and I want to make it exclusive,
that means you can input one value into one range and left the other
empty.Formula is better in this case I think.

Clara
--
thank you so much for your help

make two range exclusive
 

You can do this with Data - Validation - Custom - Formula. My assumption
is that if you have entered a value in one range then the other range should
be locked? If so then for the ranges use the following formulas...

Highlight H100:M100 then select Data - Validation - Custom - Formula
=COUNTA($H$101:$M$101)=0
Highlight H101:M101 then select Data - Validation - Custom - Formula
=COUNTA($H$100:$M$100)=0
--
HTH...

Jim Thomlinson


"clara" wrote:

Hi all,

I have two range H100:M100 and H101:M101 and I want to make it exclusive,
that means you can input one value into one range and left the other
empty.Formula is better in this case I think.

Clara
--
thank you so much for your help