The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

Filter one list depending on contents of another plus intro to hurling

by admin | May 19, 2015 | Excel | General

I recently met with a friend of a customer and after I let him into the secret of pivot tables, he asked me about helping him create two dropdown lists. The idea being that the contents of the second one would depend on what was chosen in the first one. In the example...

Excel shortcut keys – FREE

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management
  • Using Excel for tracking training

Like Excel Expert on Facebook

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved