data validation list

  1. E

    Dynamic/advanced data validation lists

    Hi everybody, I have a sheet containing (among other things) a list of personal IDs in one row, and dates in another row. This list may contain more than one occurence of the same ID, but with different dates. In another sheet, I want to be able to do like this: 1. In cell A1, enter a...
  2. W

    Dynamic List Based on Value in another Cell

    On one worksheet I have a table such as the table below. On another worksheet I have a bunch of lookups that are based off a couple of unique values. Name is repeating, but identifier is not. On another sheet, I need a dynamic drop-down list of all identifiers for a given name. For example, if...
  3. K

    How to extract data and omit blank lines?

    I have created template using data validation drop down lists used to select items relevant for a job quote. Not all items on the list will be selected at any one time so there will some blank lines left over. I would like to extract this information and send it to another formatted sheet in...
  4. R

    Dynamic array generated by a formula, and constrained by selections (no VBA)

    Guys, I don't know how to do it without VBA - hopefully you know better. Situation: I need two kind of inputs from user. First - to indicate number of unique VAT rates that are on the invoice. Any integer between 0 and 4 is allowed. Let's assume that user selected 3. Now Excel knows that there...
  5. M

    Data Validation List Dependent on Another Data Validation List

    I have a dataset in five columns (Let's call the headers "Claim Stage 1, Claim Stage 2, Claim Stage 3, Claim Stage 4, Claim Stage 5"). Under each header, I have 100 data options to choose from. What I'd like to do is have two drop-down data validation lists where the second is dependent on the...
  6. W

    Data Validation with Blank Cells

    Hi All, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a data validation range that includes cells that have no data yet and it shows up on the drop down list as empty space, is there a way to prevent it from appearing in the drop down list until...
  7. K

    Conditional formatting based on list

    I know this should be easy but it's not working. Basically, I have a schedule for training with 30 minute time slots from 8 a.m. to 4:30 a.m. In Column M, starting with M4:M15, I have a list of activities B4 needs to have data validation with the contents of M4:M15 applying conditional...
  8. A

    Creating multiple (5) drop down lists, all dependent on the selection(s) of the prior

    I need to put together a worksheet that assists users in selecting a valid account for posting activity. Prior to viewing a list of acceptable account numbers (with full descriptions), the user must 1st select from 4 other drop downs. Column A has 2 possible selections Column B has 2 possible...
  9. G

    Data Validation drop down

    Here's my question: I created a data validation on my excel sheet, is there a way to make the fonts on the drop down list bigger or even change the fonts?
  10. G

    Drop Down List with a 2nd Column for Information Only

    I have a dropdown list in my spreadsheet that identifes a code. The code does not mean anything to the users of the spreadsheet so I want to include a description with each item on the list, BUT I do not want this description to be included when the user selects the code. For example, I want...
  11. gmaboing

    URGENT: Need help with data validation and nesting if statements

    Need help with nesting and data validation BASIC BACKGROUND INFO: I have a spreadsheet that I am doing data validation with multiple dependent lists. I have setup a validation list for my first instance, and for my second instance, instead of using the 'Indirect()' command, I decided to do a...
  12. I

    ClearContents when a different cell changes

    Hi, First I want to say i'm new to this forum and already it has been a great help. Looks like there are a lot of really experienced people on here. I have a few cells that use data validation to generate a drop down lists from ranges elsewhere on the sheet. Some of those cells are dependent...
  13. J

    Populating row of cells after drop down selection

    Hello, I am using win7 64 and Excel 07. I have 2 sheets of data. Sheet2 is a table listing data in rows for a column of 20 different items. Each item has 19 different values associated with it (if that matters). On sheet 1, I want to create a similar smaller table with 5 drop downs that...
  14. R

    how to remove duplicates from list based on a dynamic named range

    Does anyone know how to remove duplicates from a list created with a dynamic named range? I have a drop down box with a list on sheet1 that is based on a dynamic named range called customer_names on sheet2. Users on sheet1 can either select a name from the drop down list or enter a new name...
  15. D

    Filter Out Duplicate Info Onto a different Sheet

    I'm using MS Excel 2000. Is there any way I can use autofilter and data validation list to sort and filter information (from a different sheet from other than orginal) and dynamically update and display it on another? Scenario: I have three sheets, one called Dashboard, Summary of All, and...
  16. B

    Sum items from Data Validation list, help

    I am trying to do what seems to be easy enough but I can not figure it out. Excel 2007 Scenario: I have a fairly large budget spreadsheet and there are money categories in column E. The categories are in a drop down using simple data validation (Federal, State, Transfer, etc.). I have a money...
  17. R

    Only adding last characters from a Data Validation list

    Hi Guys! I have just added the data validation-function (list) in a cell linked to another sheet. Lets say I have values such as "1234 Horse", "2345 Cow", "3456 Pig" and so on... Is it it possible to automatically "cut off" the characters following the four digits after it is selected into...
  18. G

    Alternative for data validation

    :) Hi everyone, Currently facing a roadblock with a drop down list data validation approach and is seeking for alternatives. The issue lies with the data list where options contains as much as 415 characters in total. Traditional data validation list only displays 255 characters and I've...
  19. ClimoC

    Sticky: Display Named Range contents based on text in cell

    Hey Excellers... I have some dynamic named ranges in sheet1, and in sheet2 I have data validation dropdown list which has the names of all the DNR's in it. What I want it to do (in sheet3, no less) is for the user to be able to pick a named range from the dropdown list, and have a particular...
  20. A

    data validation help

    Hello... does anyone know how to make a list data validation pick the information you want from your list by typing the first letter. For example.... autofilters allow only 1000 entries to be displayed. You can choose or "fast forward" to what you are looking for from the autofilter drop down...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top