data validation
15 TopicsData Validation to Auto-Populate Adjacent Cell
Good afternoon! I'm very new to using formulas and data validation in Excel, so I apologize if this question has been answered already and I didn't catch it. I'd like to see how to use Data Validation, a formula, or a combination of the two to be able to enter a specific number in one cell so that the information tells the adjacent cell to then auto-populate with the appropriate corresponding information. I have a sheet with 7,864 rows of accounts & 2 columns (screenshot 1). As you'll see in screenshot 2, I need the data from the sheet (screenshot 1) to validate the data in columns J, K, L, & M (screenshot 2) Columns J & L: this is where I will type an Account Number. Columns K & M: this is where the Account Name that corresponds to the Account Number needs to go. My goal is to be able to type in an Account Number in Columns J & L and for that to tell the next column of the same row (Columns K & M) auto-populate with the correct Account Name. All of this would be done using the the 7864 rows of data in screenshot 1. Any (very dumbed down) assistance you can offer is GREATLY appreciated!!Solved9.4KViews0likes7CommentsData validation lists - flow chart?
Hello, I'm a school leader and I'm trying to create an Excel spreadsheet to track Teaching & Learning action steps that I give to teachers. I understand how to create a drop down list but what I'm trying to do is essentially create a list within a list, like a flow chart. For example: I'm creating a Maths specific tracker at the moment that has 3 dimensions of depth and specific focuses for each dimension. So if I select the dimension of depth as "Language and Communication" then I want a list of Language & Communication focuses to appear to be selected. But if I select the dimension of depth as "Conceptual Understanding" then I want a list of Conceptual Understanding focuses to appear instead. From there I want to be able to type in the action step as normal. I've attached a very basic excel of what I'm looking for. Ideally I'd like to have just one document with a different page for each teacher rather than loads of separate spreadsheets. Is there a way that I can do this?Solved11KViews0likes16CommentsCell Validation - Drop Down Lists and Text Formatting
Hi, I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with mixed font sizes within the same cell). Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list. Would appreciate any help you can offer with this. Thank you J1.2KViews0likes1CommentDatavalidation list based on 1 criteria.
Hi, Its now I wished the customer had dynamic arrays đ But without that. How do I make a list for use with data validation, based on 1 criteria? See picture. I would like to have new list (combining first name & Last name) if they have x in construction manager column. Best regards - GeirSolved1.4KViews0likes2CommentsCustom Data Validation
Hi, I'm quite an experienced Excel programmer, but I'm facing a problem with data validation I cannot understand. I got a custom data validation for cell 'K8'. The following formula works perfectly: K5=UND(--RECHTS(TEXT(K8;"0000");2)<60;RECHTS(TEXT(K8;"0000");2)/15=GANZZAHL(RECHTS(TEXT(K8;"0000");2)/15);$O8<=WENN(Dienstverhältnis="Lehrling";ZEIT(8;0;0);ZEIT(10;0;0));K8=GANZZAHL(K8);K8>=0;K8<=2400) The following doesn't work: K5=UND(--RECHTS(TEXT(K8;"0000");2)<60;RECHTS(TEXT(K8;"0000");2)/15=GANZZAHL(RECHTS(TEXT(K8;"0000");2)/15);$O8<=WENN(Dienstverhältnis="Lehrling";ZEIT(8;0;0);ZEIT(10;0;0));ODER(K8=GANZZAHL(K8);H8<>"");K8>=0;K8<=2400) The only difference in these 2 formulas is at the end ;K8=GANZZAHL(K8); ;ODER(K8=GANZZAHL(K8);H8<>""); GANZZAHL is german for INT and ODER is german for OR. When I put these 2 formulas in separate cells they show correctly TRUE and FALSE. E.g. if I write in K5 '805' it should not work. With the first formula the data validation fires, in the second formula not. Putting the 2 formulas in separate cells both show FALSE. Is there a character limit or something? The data validation dialogue doesn't show any error... Any help is very much appreciated! Best regards Andi1.1KViews0likes1CommentSelect specific cells for data validation
Is there a way to select specific cells from a list that only show within a data validation set? For example: I have a list of fruits (Apple, Pears, Grape, Banana), but for this data validation I (the user) only want to show Apple and Grape so checkbox them so these are the only 2 fruits that appear in the drop down list in the 2nd tab. Obviously the earliest option is to just delete the fruits I don't want in the list but I want the list to stay the same, so it can be reused time and time again without having to reproduce the list. I have attached an example sheet with the contents that I am looking to use.1.1KViews0likes1CommentExcel Problem
Hi, I have a little problem with listing data from a database. I need to sort data by weeks, but i have dates so i said to Excel which date belongs to monthweek no.1,2,3.. you get the point. Then with that, i would like to list the data which are in the same week category(it has multiple columns, that's why i think it's difficult.) Thank you for help.1.4KViews0likes3CommentsExcel Problem
Hi, I have a little problem with listing data from a database. I need to sort data by weeks, but i have dates so i said to Excel which date belongs to monthweek no.1,2,3.. you get the point. Then with that, i would like to list the data which are in the same week category(it has multiple columns, that's why i think it's difficult.) Thank you for help.668Views0likes0CommentsIFS in data validation with drop down
Hello, I am trying to make an ifs statement that works with data validation. I want it to be: IFS(A1="Location1","Fred",A1="Location2","Mike",A1="Location3", *drop down of 3 names*) (If A1= Location 1 then A2 autopopulates to Fred, same with location 2 and Mike, Location 3 I want a drop down of 3 names in A2) Any ideas on how it would be able to work? Thanks!3.1KViews0likes1CommentWhen using Data Validation List with more then 8 values - drop down shows a black line
In column A I have a list of products. In column D I have Data Validation List to select from column A values. When the List contains more than 8 values, when I open the list to select a value -it shows a black line. I'm using Excel 2016 MSO (16.0.4266.1001) 64-bit but it happened on other versions as well. Is it a known issue? Is there a solution?2.2KViews0likes5Comments