data validation condition

hi, in Sheet2 I have list: <tbody> columnA (name) ColumnaB (region) Audi Euro Ford USA Chevi USA VW EURO Porshe EURO </tbody> I used manager name to define range: Cust_Name = Sheet2!$A:$A Reg_Name = Sheet2!$B:$B Now, in Sheet1 I did data validation and I have: A2 = list of name...

Hi, I am stuck with a data validation problem. I need to validate a cell to allow only characters, numbers and spaces with maximum length of 40 char e.g. My room no is 402. I have this formula =AND(SEARCH(MID(I3,ROW(INDIRECT("1:"&LEN(I3))),1),String),LEN(I3)<=40) but it doesn't allow space...

Hi , hope someone can help me with following Data validation problem: Problem 1: I have data validation in a matrix allowing a user to enter only a N or R. By processing a macro I later change the N's into X's and remove R's. When the file is saved, it is send back to the user for a next...

Hi There Is it possible to apply Data Validation to an empty cell based on the calculations in another cell? I currently have the following: H6 contains total hours worked in one shift (which is calculated with a formula) I6 contains total journey time (which is manually entered) J6 Contains...

Hi, I have an automatically updated list going down a column. (100 rows in the column have a formula and it is basically saying it equals the next figure in the list that has been selected until there are no others and it then =""). =IF(ROWS($L$3:L3)<=(COUNTIF('Purchases...

Hello I need some help to find out the best way to validate some date on my sheet. For example I have my customer PO, QTY and Part number. On the next available line the user will input the require information but let say that he/she doesn't have the Customer PO, so he/she will type the QTY but...

Row A is either going to have "Renewal" or nothing Row B, I would like a drop down list 0,1,2,3 I am looking for a formula in B1 to look at A1. If A1 = "Renewal" then 0, otherwise let me pick from the list. Thanks

Hello, I'm looking for date validation in excel. I would to control the cell with given dates like the user can able to select or enter the date only two day prior and today's date. He should not select any other date like future date or two days prior date in the particular cell (say A1). I...

Hi Team, Hope can anyone help on the below request. I have two data validation columns and I would to get the second validation based on first selection. Expecially if I select "No" in first column (A2) then in B2 data validation should not require to appear the drop down. It should block...

I'm using array formulae throughout my Excel workbook, and I'm working on part of a team. My reporting analyst will at times go through my workbooks to see how it works, but at times will absentmindedly hit 'return' instead of 'esc' when leaving an array formula, which breaks the array and...

Dear folks, Much appreciate your help with below case: Restrict cell A1 with 2 conditions: - A1 must be alphanumeric - Length must be < 19 I try OR(AND(CODE(A1)>=65,CODE(A1)<=90),AND(CODE(A1)>=97,CODE(A1)<=122),AND(CODE(A1)>=48,CODE(A1)<=57)) with the first condition but it seems like it only...

hai semua salam sejahtera.... saya newbie dan tidak mengerti sama sekali vba. saya mempunyai satu file excel dengan 2(dua) sheet 1. sheet pertama (d17:co116) dan ingin saya jadikan lembar input data, dengan data validation list katakanlah (PENDIDIKAN_AGAMA, PENDIDIKAN_KEWARGANEGARAAN dan...

I'm having issues: I have dropdownboxeslinking different sheets within the same workbook and they are dependent on each other. Example: When you select Option A in F4 (dropdown box), subsequently the adjacent dropdown box, F5, should list options under the name Red (RedA, RedB, RedC) as well...