# Expert validation...?

#### merlin_the_magician

##### Active Member
Right… posted a question on this a few days ago already, but I think things are starting to get just a little more complicated than the matter actually is. I will explain the thing again, in very simple, plain words. Hopefully this helps understanding the problem better.

Imagine this:

I have two columns, M and N. These are validated, so only the number “1” can be entered in the cells.
One should only be able to fill out eighter column m or N, not both of them. Also important: the validated value “1” is something I will need to keep!
How can I fix this? VBA code? More specific validation?

Hope somebody can help me out here!

Kind regards,
Merlin

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Ian Mac

##### MrExcel MVP
On 2002-09-04 03:29, merlin_the_magician wrote:
Right… posted a question on this a few days ago already, but I think things are starting to get just a little more complicated than the matter actually is. I will explain the thing again, in very simple, plain words. Hopefully this helps understanding the problem better.

Imagine this:

I have two columns, M and N. These are validated, so only the number “1” can be entered in the cells.
One should only be able to fill out eighter column m or N, not both of them. Also important: the validated value “1” is something I will need to keep!
How can I fix this? VBA code? More specific validation?

Hope somebody can help me out here!

Kind regards,
Merlin

Ok sorry to be abrupt BUT I have answered this question spent a lot of time explaining and explaining.
I have offered to look at your Workbook if need be.
My method works, yet you seem a little ungreatful.

Sorry if this out of order, but I spent a time span of aprox 16 hours from first to last post AND posted the morning.

If you could just send the book I'll show that it works.

Also you should carry on in the same thread:

http://www.mrexcel.com/board/viewtopic.php?topic=20885&forum=2&start=0
_________________
Share the wealth!!
Ian Mac
This message was edited by Ian Mac on 2002-09-04 03:55

#### merlin_the_magician

##### Active Member
Im very sorry Ian,
i did not mean to be rude or ungreatfull. I really appreciate the help you offered. I just figured that maybe i should ask my question again, and try to explain things more clearly.
I will not edit this post anymore and dtick to my original posting.
If you check your mailbox, you will find my workbook.

Merlin

Replies
1
Views
1K
Replies
4
Views
338
Replies
3
Views
599
Replies
6
Views
194
Replies
2
Views
714

1,181,334
Messages
5,929,372
Members
436,665
Latest member
MonkeyNotDonkey

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back