Formula Friday – How Many Sales People Have Above Average Sales Using COUNTIF Formula
Hello Excellers, welcome to some more Formula Fun on a Friday. In my scenario today, I need to know how many sales force members earn higher than the average sales. One of the quick ways to do this...
Formula Friday – Use Approximate Match In VLOOKUP Apply Grading To Student Papers
Excellers, it's time for more Formula Fun. Today I am going to show you how to use the approximate match in the VLOOKUP formula to apply Grades such as A,B,C,D etc to student papers dependant on...
Formula Friday Using DATEDIF To Count The Number Of Months Between Two Dates
Formula time. Today let's look at how to calculate how many months there are between two dates. Why?. It's a question I was reacently asked. This is useful if you have a list of dates...
Today's formula fun is inspiried by a question I received from Lyn in -to my email box earlier this week. The question was how to count a number of items in a list that met...
Formula Friday – How To Calculate The Number Of Workdays Between Two Dates Using NETWORKDAYS
Most, but not all businesses, operations or projects happen during weekdays. So, if you need to report on the number of days that have elapsed between a start date and an end date...
In Excel, unless you have a dynamic data set, or your data is an Excel table, then you may need to manually add data to your existing Excel chart if you want to display more data than your original...