IFS 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!When 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?
Summing a row of drop down lists VALUE error
Hello all, I am trying to sum a row of cells where each cell has a drop down list created through Data Validation using Excel 2010. Each list has 2 options, a blank cell or a time that is formatted in the custom format h" hrs "m" mins". For some reason when another user chooses the options from the drop down list, the formula that sums the cells presents a #VALUE error. The summing formula is =TEXT(L14+M14+N14+O14+P14,"hh:mm") and I have attached the sheet to this message. I'm thoroughly stumped as to why when others view and select from the drop down lists, the answer that is given is no longer recognised by the formula. The perfect solution would be that the formula gives out a time in either hh:mm or the above custom format, but any advice is much appreciated!Datavalidation 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 - Geir
Excel 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.Drop Down List - Linking Corresponding Data in Separate Columns Based on Drop Down Selection
Hey there! I'm looking for a clear cut way to do something which seems like it should be simple. I have two columns that I want to correspond with one another. What I'm looking to do is when someone selects an option "Status" from the drop-down list in Column D the adjacent cell in column E populates with a corresponding percentage value. Ex. --> Cell 'D6' / "Sales Status" Drop Down Selection = Verbal Commitment ::: Needing Cell 'E6' to auto-populate once selected with the corresponding percentage "100%" I've built a drop down list for each column in a data worksheet. Am I doing this correctly? I've attached a screenshot of the columns I need populated as well as my lists in case that helps. Thanks!Cell 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 J
