Excel Array Formulas Tips - All Tips (16 tips)
- Array Formulas – the Technical Side
- Counting Based on Multiple Criteria
- Count the number of cells in a range containing all types of Errors in Microsoft Excel
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum positive value in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Count the number of times dates in certain month appears in range in Microsoft Excel
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Calculating the Average Difference between List Price and Sale Price
- Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
- Ignoring Blank Cells when Performing Calculations
- Checking for the Presence of Specified Values Within a Range
- Finding the Score that Was the Nth Highest for a Specified Team
- Calculating the Average Value in Every Nth Column, Excluding Zeros
- Rounding Time Intervals to the Nearest Specified Time Increment
- Array Formulas in Excel 2007
»Click here to submit a tip to Excel Array Formulas tips
