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.
Tag Archives | Concatenate
In this video, we will look up two values in cells A1 & B1, find a match in two other columns of data and return a result from a third column from that same matching row. We will utilize the INDEX and MATCH functions while using Array formulas in the process.
In this post I will use the Consolidate Multiple Ranges option to concatenate table headers wtih the column values…..