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...
Macro Mondays – A Quick Macro To Open A Spreadsheet To A Particular Sheet And Cell
This really is a very quick #macromonday tip for you. Have you got a large Excel workbook with lots of worksheets?. It's sometimes really handy to be able to open your workbook straight to the...
Formula Friday – Use The SubTotal Function To Number Rows In An Excel Table.
Hello Excellers time for some handy #formulafriday tips. This week let's take a look at using the SUBTOTAL Function to easily number our rows in an Excel Table. You may want to number...
Formula Friday – Quickly Convert Formulas To Cells Values In Excel
Happy Friday Excellers, and welcome back to some more #formulafriday fun. Today let's take a look at how to easily display only cells values and not the Excel formulas that you have...