Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation problem.
Lets make this very simple. I have two cells. Lets call them A1 and B1. I
want the cells to be blank or contain just "X". Anything else should not be allowed. This i can solve by making a validation rule.I have solved this just by makeing a list that just contain "x", so you get a dropdown box with just x in it. But both cells cant contain "X". This can i allsow solve by makeing a validation rule. Here i just added =A1="" in the validation. And offcourse i can add =B1="" in the other valiation cell. The problem is that i cant solve both. Need help with this one. Plz. I dont want to use buttons..cuz this will apply to over 1000 cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation problem.
Select A1 and B1. Apply this formula in Data Validation:
=(COUNTIF($A$1:$B$1,"="&"X")<2) "Petter" wrote in message ... Lets make this very simple. I have two cells. Lets call them A1 and B1. I want the cells to be blank or contain just "X". Anything else should not be allowed. This i can solve by making a validation rule.I have solved this just by makeing a list that just contain "x", so you get a dropdown box with just x in it. But both cells cant contain "X". This can i allsow solve by makeing a validation rule. Here i just added =A1="" in the validation. And offcourse i can add =B1="" in the other valiation cell. The problem is that i cant solve both. Need help with this one. Plz. I dont want to use buttons..cuz this will apply to over 1000 cells. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation problem.
Thx, but this not solve the problem with the first issue. The user can still
put anything want they into the cell. This should only be restricted to either blank " " or "x". "Stephen" wrote: Select A1 and B1. Apply this formula in Data Validation: =(COUNTIF($A$1:$B$1,"="&"X")<2) "Petter" wrote in message ... Lets make this very simple. I have two cells. Lets call them A1 and B1. I want the cells to be blank or contain just "X". Anything else should not be allowed. This i can solve by making a validation rule.I have solved this just by makeing a list that just contain "x", so you get a dropdown box with just x in it. But both cells cant contain "X". This can i allsow solve by makeing a validation rule. Here i just added =A1="" in the validation. And offcourse i can add =B1="" in the other valiation cell. The problem is that i cant solve both. Need help with this one. Plz. I dont want to use buttons..cuz this will apply to over 1000 cells. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation problem.
My apologies. Try this formula instead:
=AND(OR(A1="",A1="X"),(COUNTIF($A$1:$B$1,"="&"X")< 2)) (The first two cell references are meant to be relative.) "Petter" wrote in message ... Thx, but this not solve the problem with the first issue. The user can still put anything want they into the cell. This should only be restricted to either blank " " or "x". "Stephen" wrote: Select A1 and B1. Apply this formula in Data Validation: =(COUNTIF($A$1:$B$1,"="&"X")<2) "Petter" wrote in message ... Lets make this very simple. I have two cells. Lets call them A1 and B1. I want the cells to be blank or contain just "X". Anything else should not be allowed. This i can solve by making a validation rule.I have solved this just by makeing a list that just contain "x", so you get a dropdown box with just x in it. But both cells cant contain "X". This can i allsow solve by makeing a validation rule. Here i just added =A1="" in the validation. And offcourse i can add =B1="" in the other valiation cell. The problem is that i cant solve both. Need help with this one. Plz. I dont want to use buttons..cuz this will apply to over 1000 cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with data validation | Excel Worksheet Functions | |||
data validation problem | Excel Discussion (Misc queries) | |||
Problem with validation arrows | Excel Discussion (Misc queries) | |||
Problem with Data Validation | Excel Discussion (Misc queries) | |||
Validation problem... | Excel Worksheet Functions |