Formula Friday – Insert The Current Filename And Path In A Cell Using the CELL Formula
So, hello Excellers, welcome my first #FormulaFriday #Excel blog post in my 2020 series. Welcome if you are new to my blog and welcome back if you are a regular reader. Today let's look at a...
Conditional Formatting Excel Cell Text When A Formula Changes To A Typed Value- Formula Friday
Hello, Excellers welcome to today's #formulafriday blog post. Today let's look at using conditional formatting formula to change Excel cell text colour when a formula is replaced with a value. In...
Hello Excellers, and it is that time of week again. It is time for some more Excel formula fun. Today I want to share with you a great excel tip. I am going to show you how to generate random...
Formula Friday – Which Range Does My Value Fit Into – A Perfect Job For The LOOKUP Function.
Hello Excellers and welcome to another #formulafriday. Today let's look at a an Excel function that can return a value from a range (a row or a column). LOOKUP is one of Excel's lookup and...
Happy #formulafriday Excellers. Today we are going a little left of field, and looking at the really useful LEFT Function in Excel. This a a really useful function to have in your Excel toolbox...
Formula Friday – Shhhhh…Want To Hide Your Excel Formulas?????….
Hello Excellers, and welcome back to another blog post in my #Excel series. So, something a little different for today's #formulafriday blog. Instead of showing our Excel formulas, I...