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

      Most Popular Blog Posts

      How to extract a unique distinct list from a column

      How to return multiple values using vlookup

      Create a date range using excel formula

      Count unique distinct values in a column

      Sorting text cells using array formula

      How to create a dynamic chart

      Match two criteria and return multiple rows

      Merge two columns into one list

      Lookup with multiple criteria and display multiple search results using excel formula

      Find latest date in a list

    • 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.
    • Random Data Generator 250x250 ad 3
    • 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.


    You are here: Home >> Excel >> Drop down lists

    Archive for the ‘Drop down lists’ Category

    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 Page — « previous entries
    next entries » — Next Page »
    • Related blog posts

      • Search case sensitive and return multiple values in excel
      • Create dependent drop down lists containing unique distinct values in multiple rows
      • Search for a text string and return multiple adjacent values
      • Vlookup – Return multiple unique distinct values in excel
      • Excel: Look for values containing a lookup value and return multiple values horizontally
      Add RSS 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

      • Oscar on Learn how to return values depending on udf deployment (vba)
      • Monirul Islam on How to return multiple values using vlookup in excel
      • Rick Rothstein (MVP - Excel) on Learn how to return values depending on udf deployment (vba)
      • Paul on How to return multiple values using vlookup in excel
      • Karen G on Match two criteria and return multiple rows in excel
      • S.Babu on Match two criteria and return multiple rows in excel
      • S.Babu on Vlookup across multiple sheets in excel
      • Oscar on Concatenate a cell range without vba in excel
      • Oscar on Compare two tables in excel: Remove common rows
      • Oscar on Excel udf: Lookup and return multiple values concatenated into one cell
    • Recent Posts

      • Lookup multiple values in different columns and return a single value
      • Learn how to return values depending on udf deployment (vba)
      • Select a cell in a table and the chart updates automatically (vba)
      • Excel template: Getting Things Done (vba)
      • Disable autofit column widths for all pivot tables in a sheet
      • Vba macro: Normalize data
      • Date ranges: Weeks within a month
      • Add values to different sheets (vba)
      • Add values to a table (vba)
      • Unique distinct records sorted by frequency