In this tutorial we’ll look at how to dynamically pull the salaries of all employees from a list, for the period of the date selected.
Tag Archives | Array formula
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.
Here is an array formula you can use to find the last non-zero entry in a column. We will use the IF and LOOKUP function in the process.
Here we are going to use the MAX and IF functions in combination to look up a value in an array. We will also incorporate the INDEX and COLUMN function to assist us…..
Here is an example of using the array formula process in Excel to determine the MIN number in a list…..
Here we are going to sum the absolute value of a list of numbers based on a criteria from another list in Excel: