Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data List - Write to another cell with check
Let say in excel cell A1 and B1, I created a List using Data Validation, and
put in value 1,2,3,N/A So that cell A1 and B1 each will have drop down list 1,2,3, N/A Now, How can I achieve following with formula: - If in cell A1, after I select value 2 for example, it will check if B1 has select the same value 3, Pseudocode is like this: If B1 is empty or B1 has N/A, write value 2 that selected into Cell C1 else If B1 has the same value as A1( in this example: 2) it will prompt error, saying that value 2 has been selected in another cell.and user has to select other value in cell A1 else Compare the value with cell B1. if B1 value < A1 Value write B1 value into Cell C1 else write A1 value (which is 2) into Cell C1 end if end if same check goes to Cell B1 Please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data List - Write to another cell with check
To add on,
If in Cell A1, if I select N/A, no check will be done. Same goes to Cell B1 "magix" wrote in message ... Let say in excel cell A1 and B1, I created a List using Data Validation, and put in value 1,2,3,N/A So that cell A1 and B1 each will have drop down list 1,2,3, N/A Now, How can I achieve following with formula: - If in cell A1, after I select value 2 for example, it will check if B1 has select the same value 3, Pseudocode is like this: If B1 is empty or B1 has N/A, write value 2 that selected into Cell C1 else If B1 has the same value as A1( in this example: 2) it will prompt error, saying that value 2 has been selected in another cell.and user has to select other value in cell A1 else Compare the value with cell B1. if B1 value < A1 Value write B1 value into Cell C1 else write A1 value (which is 2) into Cell C1 end if end if same check goes to Cell B1 Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check List Cell | New Users to Excel | |||
Is there function to check and list data? | Excel Worksheet Functions | |||
I have a data list of 7,000, what is the easiest way to check for | Excel Worksheet Functions | |||
check to see if cell contains a string = to member of list | Excel Programming | |||
How to check for next empty cell in list | Excel Programming |