advanced data validation

  1. C

    Data validation formula to return list of orders based on vendor

    Good day, I am trying to setup a formula-driven data validation list that will give me the option to select order numbers based on the vendor. The problem I have is that the maximum limit of character-input for a formula is 256 characters, this creates a big problem in my sample, as I am using...
    • Cyberpunk001
    • Thread
    • advanced data validation data validation (list) named ranges array
    • Replies: 7
    • Forum: Excel Questions
  2. W

    excel drop down list to populate multiple columns

    hello, Can anyone please send me there suggestions on how to automatically populate a range of columns. As of now, I have a manually created reference chart located on sheet 1: <tbody> * B C D E F G H I J K L M N 3 * ALBANIA ALGERIA ARGENTINA ARMENIA AUSTRALIA...
    • wakefield101
    • Thread
    • advanced data validation data validation data validation (list) excel formula
    • Replies: 0
    • Forum: Excel Questions
  3. C

    Conditional Data Validation through List

    Hello experts, I have applied data validation through list in excel 2013. That list contains some cells in which text does not start with two minus signs i.e. "--". I want my data validation to expand in such a way that only cells started with "--" are picked and other are not allowed...

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