Create a dynamic hyperlink using an array formula!
This means that you can jump to a location in your data depending on conditions in the values.
This is one of my favorite ways to use an array formula! Continue reading
This means that you can jump to a location in your data depending on conditions in the values.
This is one of my favorite ways to use an array formula! Continue reading →
Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: This time I use the SUMPRODUCT function for a quicker solution. SUMPRODUCT can be used to count with conditions (within the same group).
Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: I use functions VLOOKUP, AND to identify rows if a condition is met within the same group. Continue reading →
Learn how to add numbers in Microsoft Excel using these functions: SUM, SUMIF, SUMIFS. Continue reading →