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...
Tag: Excel Formulas
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...
Formula Friday- Calculate How Many Days Until The End Of A Sales Campaign
Hey all, and it's time for another Formula Friday.... Today I want to share with you a query recently sent to me by Daniel. He wanted to calculate how many days he had left in a campaign. ...
So another Formula Friday is upon us. Here is a formula trick for not creating a formula, but pausing whilst you are in the middle of creating your formula and not losing your place or...
Formula Friday- How To Use LEN in Excel To Highlight Issues With My Data Import
Yes Friday again more Formula Fun time. Today it's exploring the LEN function. It really is one of the core text formulas to have in your Excel Toolbox. It is used to return the...
Hey Excellers Happy Friday. You can download the sample file for this Excel tip here [ddownload id="7101"] Today let's look at some formula fun. Lets use Excel to pick a winner from a list...