As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading
I was thinking about this on Friday…. It’s got to be more than just the final score point difference.
Sure, an exciting finish like the 1991 Giants vs Bills game is a classic. Continue reading
Are you a small business owner or are you thinking of starting a small business?
Do you wish you had more hours in a day?
If you answered yes to both of these questions then you should do an audit of all of your tasks to see where you can save time.
I created a free template called ‘Small Business Outsourcing Template’ that will help you determine where you need help.
You can download the file here or here from my OneDrive. Feel free to clear the data input range in sheet ‘3 Task Input’ and add you own data.
I also created a video that shows you how to use the template. Watch the video
It can be REALLY painful! Over the years I have used various techniques to audit Excel files.
This post shows you how to distinguish between different error types, count them and find them!
If we know the value of x we can easily determine if the left side = the right side.
But in this case x is not a single value but rather a Domain (a set of numbers). x can be 5, 6, 7 or 8. We have four chances to get a true answer.
Here is the Excel formula —> {=OR(9*{5,6,7,8}-7=47)}
Step 1: Multiply the 9 with each number inside of the array constant: {=OR({45,54,63,72}-7=47)}
Step 2: Subtract 7 from each of the numbers inside of the array constant: {=OR({38,47,56,65}=47)}
Step 3: Compare each number with 47 (TRUE means it’s the same): {=OR({FALSE,TRUE,FALSE,FALSE})}
Step 4: The final answer gives us TRUE (The OR function just needs 1 TRUE)
Download here or via my OneDrive (file 00070)
See how I caught the issue and several ways to fix it.
OR function, constant array (that contains the 5,6,7,8), entered as an array formula that requires Control Shift Enter (not just enter).