Imagine a column of numbers. Each number is 3 digits in length.
If we select 127 then we want to also hide 127, 172, 217, 271, 712, and 721 (six unique orders).
In this video I show you two possible solutions. Continue reading
If we select 127 then we want to also hide 127, 172, 217, 271, 712, and 721 (six unique orders).
In this video I show you two possible solutions. Continue reading →
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.
There are many different on-line wedding planners. For example, click here to see Marha Stewart’s on-line wedding planning tool. Continue reading →
There’s a lot of confusion about data and time values in Excel but it’s easy to learn! Continue reading →
Enter strengths, weaknesses, opportunities and threats. For each entry, you select “Y” to display it in the output sheet or “N” to hide it (no need to erase the entry and then have to type it back in later). Continue reading →
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).