Excel Helper Column | Exceljet

Skip to main content

You are here

Home › Glossary › Helper column Helper column

A helper column is a non-technical term to describe a column added to a set of data to help simplify a complex formula or an operation that would be otherwise difficult. The concept is a little abstract, so here are three examples:

1. You can use VLOOKUP to perform a lookup with multiple criteria by adding a helper column to the data. In the example above, a helper column is used to concatenate first and last names, so that VLOOKUP can be used to find departments using both names. Click for details on this formula.

2. You can use a helper column with a formula that returns a value like TRUE for rows that meet specific conditions, then use go to special and delete only those rows. Watch this video to see a "shortcut recipe" to remove specific rows using this technique. The recipe using formulas starts at about 6:00 in the video.

3. You can use a helper column for sorting. For example, you could add values to a helper column to sort a table in ways not easy or possible with the original set of data. You can also use a helper column to preserve and restore the original sort order.

Topics

• Formula Basics
• Formula Examples
• Conditional Formatting
• Pivot Tables
• Excel Tables
• Excel Charts
• Shortcuts
• More...

Key Functions

• IF function
• VLOOKUP function
• XLOOKUP function
• FILTER function
• SUMIFS function
• COUNTIFS function
• SUMPRODUCT function
• INDEX and MATCH
• New Excel Functions
• All Excel Functions

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

  

Just a big thanks! You were the first that were able to explain Index and Match in a practical, straightforward, non-excel guru oriented way! Jacques More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles