data valadation

  1. L

    Data validation with unique formula

    I want to create a list with data validation taking unique values of the column #date of a table
  2. E

    Help to shorten formula to fit into data validation

    Hey all, I am needing to shorten this formula so I can put it into a data validation drop down list. =IF($c$11="1", 'LI'!$A$9:$A$99, IF($c$11="2", 'LI'!$b$9:$B$99, IF($c$11="4", 'LI'!$d$9:$d$99, IF($c$11="5", 'LI'!$e$9:$e$99, IF($c$11="6", 'LI'!$f$9:$f$99, IF($c$11="7", 'LI'!$g$9:$g$99...
  3. A

    VBA Code Help - Multiple Data Validations with Unique Error Messages

    Hi there, I'm very green to VBA and am trying to write a code to run multiple data validations in tables, each with their own hard stop error message. The spreadsheet is a data entry spreadsheet and here are the rules: 1) data entered in cell must be numeric - Shading cell with light red color...
  4. C

    VBA search page hyperlinks from data validation list

    Hello, I've a "search" page that loops through all the sheets to return data to my search page and produce a hyperlink to each sheet said data is found. One of the search criteria is from a data validation list. I believe this is messing up the ordered list of search results. I have the code...
  5. J

    Dynamic Valuelist based on selected dropdown

    I'm fairly new to excel. I have googled this with no help. I will try to explain this the best way I can. I have a field that I created a dropdown from a named range. I then want to use the value selected to create another dropdown list, but its filtered to only display certain values from the...
  6. S

    How to enter a specified digits in a cell if another cell has a certain text

    Brand Shipment Code PH 7 digits PC 8 digits Okay! PH and PC are two brands in my logistics organisation, the thing is the shipment code of PH is 7 digits and PC is 8 digits what I want is when i enter PH the shipment code should only be 7 digits if its more than that then it should...
  7. T

    Copy and Paste Data Validation

    Hello, I have a data validation set up from a range of cells by formula SUM($B$2:$G$2)<=1. In other words, I want an error message to show up if the total for cell B2:G2 is greater than 1. Is there an easy way to apply this to B3:G3 all the way down to B166:G166 without having to do it one at...
  8. Carl Colijn

    Excel dynamic data validation + named ranges + invalid typed data — broken, or never worked?

    Hi all, Note: I already posted this question on Stack Overflow, but I guess that post there isn't going anywhere, so I think it's time for some cross-posting. I have a dynamic list of category options I want to present in some cells using a data validation drop down. This list is ('admin')...
  9. C

    Hide / Unhide tables based on a list chosen

    Hi all, I’ve got a sheet with 4 tables on it. I have a cell in B2 with data validation set to a list on another sheet. I can currently hide or show the tables based on either columns or rows. As one table is shown the others are hidden. What I’m wandering is if it is possible to hide or...
  10. S

    Conditional Data Validation list

    Hello everyone, I have two name range lists as follows Fruits Orange Apple Banana Coconut Apricot Vegetable Cucumber Eggplant Pumpkin Squash Tomato I am looking for a solution to use the above lists under data validation with if condition. For example If i Put...
  11. J

    Alternatives for INDIRECT in cascading (dependent) dropdown lists causing slowdown and headaches

    Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...
  12. B

    Creating dependent list

    Hello all, I have a spreadsheet with a number of companies, each one with 3 specific values that I would like to be able to put in and out of spreadsheets. When I select one of my companies using data validation list I would then like the 3 corresponding values to automatically fill in the...
  13. I

    Multi-select from data validation isn't working in conjunction with auto-assigning data validation

    I have a sheet within my workbook where I'm trying to do a couple related things at once that I think may be messing with each other. I am applying data validation on the fly first -- in other words, every time I click on a cell in a given range on my sheet "User Lists" it checks the header of...
  14. B

    Prevent specific text being entered into a cell

    Is there a way I can prevent users being able to enter the text "N/A" or "None" into certain cells using data validation? in cell A1 is "What is the name of your current employer?" in cell A2 is a blank cell where the user would answer. If they are unemployed I don't want N/A or None being...
  15. S

    Tooltips for drop down list options

    I have a lot of drop down lists (using "data validation") and I'm wondering if there is anyway to have tooltips for each option in the drop down list?
  16. G

    Data Validation

    Hi I am trying to do a data validation list where only the on the form below where if I mark a one in any of the columns in blue I only get these result from my data validation list rather than them all. So if I have a 1 in Type Specific and Land Reg columns then on the same row under...
  17. N

    Excel - Lock Cells based on value of another cell in row from a list and not use a value unless another value is used first

    I’m trying to create an attendance workbook with each sheet being the month, with multiple rows/column. I have created a drop down list to choose from on a different worksheet. What I need is the following; HVX and HVP can only be used if HV has been used in the cell before. If D is used then...
  18. N

    Data Validation Alternative?

    Hi, I'm currently working on a Dashboard that is made available to the users through SharePoint 2010. I would like for the users to be able to change currency on the Dashboard so i have come up with a fairly simple solution where the users select currency from a Data Validation drop-down...
  19. A

    Using VLookup with a Dynamic Filename within a data validation

    Hey Friends, I've been looking and looking but cannot find answers to my question. I have a macro that gives a list of filenames within a folder. I then used data validation to put the file names in a list. What I now want is to be able to write a vlookup that spits out data based on what file...
  20. J

    Auto correct/populate drop downs

    Hi all, First time poster - bare with me please! I have a spreadsheet that is very dependent on selected location. I currently have data-validation dropdown lists for continent, country and city - the formula for each list is =indirect('previous dropdown'); ie the 'Continent' dropdown is in...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back