data validation

Hi I have 4 lists and I would like to use data validation selecting from these 4 lists to give me one of 4 possible text outputs as below What is the best way to do this please - do i need to list out all the possible combinations and my desired outcome for each somewhere on the sheet or is...

Hello, I've searched this forum and many examples on google of a formula or data validation list formula that might accomplish my needs to no avail. I'm looking to populate a dropdown box's list of values from a table on another sheet that matches a cell value. I've seen many examples of the...

Hello, I'm trying to do something that i'm honestly not confident that can work as I imagine. Lets assume that I have cell A1, where I can have "Sunday" or "Weekday" In cell C1, tha data will depend on what is in cell A1, So, if I have "Sunday" in cell A1, I want cell C1 to be empty, but if...

allow to enter value in cell, only if 1. data contain 1 time "x" value between two numeric value . & both numeric values should not be more than 99, e.g 34x45.5, (allow)...... 21x56.44 (allow) 23c45.5, (not allow). 23 x 45.5 (any space not allow) 101x22 (numeric more than 99 not allow)

Hello, I'm trying to add Data Validation to 50 cells in a column that will only accept: Alphanumeric Hyphens (dashes) No restrictions for length. I did find some examples, but they are all for a single cell. If I try to change it to a range it breaks and won't let me save. I tried this...

What would be the FORMULA to list the numbers between the value of a cell and 1? Basically finding all whole numbers between 1 and the value of the cell. Example (Source) A1 = 4 (Result) B1 = 1 / B2 = 2 / B3 = 3 / B4 = 4 / etc. Purpose, I want to enter a number into a cell (A1), and create a...

Hi, I have a data table of financial securities, each item(row) corresponding to a certain country/region of issuance. I would like to have that table filtered automatically to show only those securities issued from a specific country and region selected from a dependent drop-down list...

Hi, there are many rows in my worksheet. For all cells in one column of this worksheet, I want that user can enter multiple options from a list. How can that be done? For e.g. I have 10 rows, and each cell from A1 to A10 represents a person. Then, there is a list of items that a person can...

I have the following table: Brand Type ProductName Brand A 100 Product_01 Brand A 100 Product_02 Brand A 200 Product_03 Brand A 200 Product_04 Brand A 300 Product_05 Brand A 300 Product_06 Brand B 100 Product_07 Brand B 100 Product_08 Brand B 200 Product_09 Brand B 200...

I am trying to make a Data Validation list from one of my tables, but I can't seem to get the UNIQUE function to work in the Name Manager. If I create a new Name called "Sports" and use the formula =tblGear[Sport], it works just fine. However, I want the unique values from there. I don't want it...

Hi. I have a question about data validation. Is there a way to remove one of the strings from data validation list if it's already been used in a row above in the specified range? A quick example of what I mean. Lets's say in column A1:A30 each cell has a data validation list of 'A', 'B', 'C'...

Hi, As my excel version does not have filter, sort, unique functions I have to use other set of formulas to search the drop down list in data validation. Column C Column D running shoes adidas cooking salad eating chocolate cookies sleeping at friend's house baking cookies...

Hello! Tried finding a response in these threads but no such luck. I don't know if this is possible but basically, I currently have this data validation set: =COUNTIF($E$1:$E$10001,E1)=1 So that no repeating data can be put into a single column. However, I need to make an exception for "n/a" to...

Hello, i am wanting to see if there is vba code that can delete data validations from cells. I have a data validation on cell D66 on "Sheet 1". This validation is repeated every 3 columns over so like an offset from column D of 3, Column G, J, M, etc. Is there something VBA to delete these...

Hi all, hoping someone can help with this one. I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or...

Hi. I need some assistance. Let's say that I have 10 available words in an excel table. In another table, I would type in one of the 10 words. How do I do the formula so the original table shows only the remaining 9 words? Example. TEST1 TEST2 TEST3 etc down to TEST10. I go into another cell...

I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...

I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior: 1. The combobox can appear and hide by certain action e.g...