Happy Friday Exellers . You may have already come across this problem, and if you have not, you probably will at some point when using Excel. The mysterious case of your formula is showing in the...
Category: Blog
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...
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...
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...