Get Digital Help
  • Home
  • Templates
  • Products
  • Categories
    • Advanced Filter
    • Automate
    • Combine/Merge
    • Compare
    • Conditional Formatting
    • Count Values
    • Dates
    • Drop Down Lists
    • Duplicate Values
    • Finance
    • Misc
    • Pivot Table
    • Random
    • Records
    • Search/Lookup
    • Sort Values
    • Templates
    • Unique Distinct Values
    • Unique Values
    • Unique Values
    • User Defined Functions
    • VBA
    • VLookup
    • Unique/Duplicates
    • Sort values
    • Count values
    • Search/Lookup
    • Microsoft Excel
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read
      Popular categories

       Automate

       Charts

       Compare

       Conditional formatting

       Count values

       Dates

       Drop down lists

       Misc

       Pivot tables

       Search/Lookup

       Sort values

       Tables

       Templates

       UDF

       VBA

       Vlookup

      • Advertise Here

      Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.


      Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.


    Get Digital Help > Excel > Drop down lists

    Archive for the ‘Drop down lists’ Category

    Use a map in an excel chart
    Dynamic data labels in a chart
    Run a macro from a drop down list (vba)
    Use a drop down list to change conditional formatting
    How to use a table name in data validation lists and conditional formatting formulas
    Use a calendar to filter a table
    Use filtered table values in a drop down list (vba)
    Use a drop down list to extract and concatenate unique distinct values
    Use a drop down list to select company info in header (vba)
    Apply data validation lists dynamically (vba)
    Dependent data validation lists in multiple rows
    Basic invoice template in excel
    Use a drop down list to search and return multiple values
    Change chart data range using a drop down list (vba)
    Change pivot table data source using a drop down list
    Dependent drop down lists – Enable/Disable selection filter
    Create a drop down calendar in excel
    Invoice template with dependent drop down lists in excel
    Create dependent drop down lists containing unique distinct values in multiple rows
    Apply dependent combo box selections to a filter in excel 2007
    Create a drop down list containing alphabetically sorted values in excel
    Create dependent drop down lists containing unique distinct values in excel
    Extract dates using a drop down list in excel
    Create a drop down list containing only unique distinct alphabetically sorted text values using excel array formula
    « previous entries
    Next Page »
    • Subscribe subscribe  
    • Blog updates by email:

    • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
      Don´t forget to add my RSS feed and subscribe to new blog articles by email.
    • Recent Comments

      • William on Create a unique distinct list of a long list without sacrificing performance using vba in excel
      • Jan on Formula for matching a date within a date range in excel
      • Durgesh on Calculate your stock portfolio performance in excel
      • Durgesh on Calculate your stock portfolio performance in excel
      • Alaa Abdullnabi on Merge two columns with possible blank cells in excel (formula)
      • Glenda on Populate a list box with visible unique values from an excel table (vba)
      • Anil R. on Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
      • Oscar on Auto refresh a pivot table in excel
      • Beth on Sum values in a range where adjacent cell value equals a criterion in excel
      • Oscar on Use multiple conditions in Vlookup
    • Recent Posts

      • Count students
      • Use a map in an excel chart
      • SEARCH and FIND functions
      • Yet another excel calendar
      • MMULT function – Matrix multiplication
      • SMALL function and LARGE function
      • Copy/Rename a file (excel vba)
      • Assign each person with randomly unique objects as a daily activity
      • ROW function explained
      • Highlight duplicates in a filtered excel defined table
    Oscar Cronquist