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--...
Hey, Excellers time for more Friday Formula Fun. Today let's look at how to deal with the #N/A error we get when no match is found when using VLOOKUP. It's a handy error as it tells us when there...
Happy Friday everyone- time for formula fun. Today let's look at adding a column of values so they add cumulatively or sometimes known as a running total. As ever let's take an example. I have...
Hey all, Friday Formula Time Again....today let's look at how to easily keep track of what your formulas actually mean. When you are creating a formula or many formulas as is usually the case in a...