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'?. ...
Turn Off Rounding In Excel And Use The TRUNC Function – Formula Friday
Hello, welcome to another #formulafriday blog post for some more formula fun on a Friday - why not?. Today let's take a look and explore the issue of Excel rounding or not rounding numbers. You...
Why Is My Formula Not Auto- Completing When I Type The Equals =Sign – Formula Friday
Hello Excellers, and welcome to another #formulafriday blog post. I want to share with you an issue one of my subscribers had. Their Excel was not behaving as 'normal'. When they began to...
Generate A List Of Files In A Folder – Without Macros or VBA Code – Formula Friday
Hello, Excellers have you come here for some more #formulafriday fun. Good. Me too!. Today let's look at a really cool way to generate a list of files in a folder without any macros, coding or VBA...