In this tutorial we’ll take a look at how to create a simple dashboard using a combo box, a chart, an INDEX/MATCH combination formula and a few simple formatting concepts to easily evaluate the sales for any individual salesperson.
Tag Archives | INDEX
In this tutorial we are going to explore a variation of the traditional INDEX/MATCH combination to extract and sum only a portion of a row or column within an array.
In this tutorial we’ll take a look at how to add a column with a formula outside of our PivotTable for project analysis that pulls results from a Table, then use Conditional Formatting to dress it up.
I recently received a request to use Conditional Formatting when performing two different comparisons on two data ranges. How I approached the task was WRONG! Read on to see how I finally got myself on the right track.
In this video we’ll look at the traditional data range lookup using the INDEX and MATCH functions, but add a twist to look up the values in a table, plus a bonus twist using the INDIRECT function.
This video will take you through the steps of creating a chart that dynamically changes based on the selection you make from a Data Validation drop down list. We’ll use various functions including INDEX, MATCH, COLUMNS, and ROWS.