We can use Excel’s MIN function to find the minimum number in a range. As date values are technically numbers, the MIN function can show the oldest date.
We can use Excel’s MIN function to find the minimum number in a range. As date values are technically numbers, the MIN function can show the oldest date.
In this video, the array uses the EXACT and LEFT worksheet functions. Continue reading →
In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading →
I have heard this question so many times over the years! If you have never ever used an array formula than this video is for you.
Don’t worry….No prior knowledge is required. I explain things slowly. 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 →
Use Excel’s data validation feature to restrict values that can be entered into cells.
Data validation can save you hours of data cleanup work! Continue reading →
A hyperlink is an easy way to jump from one location to another location. The destination could be to the same workbook, an external workbook or a website.
There are two ways to create a hyperlink in Microsoft Excel: Continue reading →