In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

Our task is to create a single list of values repeated across any two columns. We’ll start with quarters 1 and 2. With a quick glance, we can easily see that June is in both columns.

How to add helpful prompts to Microsoft Excel cells Enhance your spreadsheets by providing on-the-spot instructions.