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...
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...
Use VLOOKUP formula without an exact match….to calculate sales commission
Sometimes you do not actually want an exact match on a VLOOKUP....really?.... I know most times when using VLOOKUPS we do, want that exact match, but what...