Hi, Excellers welcome again to my #formulafriday blog post series. Today I want to share with you a great little hack for your chart axis labels. If you find yourself with a shortage of real...
Category: Formulas
Highlight Weekend Dates In Your Data Set. Conditional Formatting Using A Formula – Formula Friday
Hello Excellers and welcome to another #formulafriday blog post. Today let's take a look at using conditional formatting along with an Excel formula to highlight dates in our data set that fall on a...
If you have been using Excel for a while you probably have used, or have been sent a spreadsheet with at least one hyperlink in them. These work really well until the order of sheets is changed,...
Make Your Excel Hyperlinks Dynamic – Using The Hyperlink Function – Formula Friday
Hello, Excellers. Time for some hyperlink fun in Excel today. If you have been using Excel for a while you probably have used, or have been sent a spreadsheet with hyperlinks in them. These...
How To Write An Excel VLOOKUP Formula With An IF Statement – Formula Friday
Hello Excellers, I am delighted to share another Excel #formulafriday Excel tip with you today. If you have used Excel for some time, you probably know how to use a VLOOKUP formula. If you do not...
Count How Often A Value Occurs In A Data Set – Using The COUNTIF Formula – Formula Friday
Hello Excellers, today lets look at an Excel question that a twitter follower sent to me. Their question was 'how do I count how many times a certain word was used or appears in data set'?. ...