drop downs

  1. E

    Hiding rows based on a cell value with multiple values

    Hey everyone, I'm trying to write a code that hides rows based on cell value, but with a twist. The cell that it is based off of is a drop down. I have it to where you can select multiple options within the cell. I have a list of colors in the drop down and at the end I have a "Special Color"...
  2. J

    Hiding and Unhiding Columns based on multiple drop down lists

    Hi Gurus, I have a stomper. I am trying to hide/unhide columns based on three different drop down lists. The below formula works to hide/unhide when individual drop down lists are selected, however does not work together to "filter down" and show only the columns that apply when all three...
    • JoRyBar
    • Thread
    • drop drop downs end hide/unhide columns target.value
    • Replies: 0
    • Forum: Excel Questions
  3. A

    Remove duplicates from drop down list

    I have a spreadsheet with three columns of data. Column 1 and 2 have multiple matches. Column 3 are all unique values. I am trying to make three drop downs that only show unique values in each based on the selection from the previous drop down. However, only tutorials I can find have 2 columns...
  4. L

    Using Data Validation & If Formula

    Bonjour all, First time poster! Been using this site to help me make some spreadsheets for work. All have been a great help and have been learning new things and tricks every day. Anywho! Thats enough of me....I have a problem I am trying to get around and wondering if you all could help? I...
    • Literae
    • Thread
    • data validation drop downs formula if formula validation
    • Replies: 1
    • Forum: Excel Questions
  5. R

    Currency/Accounting Options

    Is it possible to change the currencies shown as options in this drop down list? I am constantly using two or three currencies and would like to be able to add the other two that aren't USD to that list?
  6. T

    Creating Multiple Dropdowns

    Hi, I've encountered a very frustrating situation after conquering what I thought had been the hard part of my project. I spent a good part of today looking around on Google and this forum in search of a solution without having any success, so I'm hoping someone can give me a hand! What I'm...
    • Tmf215
    • Thread
    • drop boxes drop down list excel drop down lists drop downs dropdown box help
    • Replies: 1
    • Forum: Excel Questions
  7. S

    creating drop down list based on prev drop down selection

    What im trying to do is set up a contact sheet in the back of a workbook company, contact name, ph, fax, cell, email and then on our proposal page i want a drop down that allows you to select the company(with no duplicates) and based on that selection it will give you a drop down for the...
  8. gmaboing

    URGENT: Trying to ALLOW Special Characters When Using Data Validation in excel

    I've seen lots of help on how to disallow special characters when using data validation but nothing on how to ALLOW special characters. I have a pretty big spreadsheet that I'm working on that will be pushing the limits of data validation :). I'm really trying my best not to change the names...
    • gmaboing
    • Thread
    • data validation drop downs lookups special characters
    • Replies: 7
    • Forum: Excel Questions

Watch MrExcel Video

LET Function Second Look: Reusing Variables! 2326

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 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
Top