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 – Convert A Vertical Data Range Into A Table Using The Indirect Function.
Friday , Happy Friday.....Formula time..... Ok, so I get a lot of downloaded, imported, exported data in all sorts of files and formats. Sometimes tabular data can be imported into Excel as a...
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...
Hi Excellers yet another Friday so that means Formula Time!....yay....so today...something that I have been looking at recently as asked by one of my Newsletter subscribers- that is--...