Excel FILES Function Thumb

Excel function to list files in a folder without VBA

Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas.  I could tell you to turn to VBA macros or PowerQuery, but then any non-VBA and non-PowerQuery users would close this post instantly.  But wait!  Back away from the close button, there is another option. For Read More

Change image based on cell value Thumb

3 ways to change an image based on a cell value

From stock parts to holiday villas, from employees to logos, there are many reasons you may want to automatically change an image based on a cell value.  In this post, we’ll explore 3 different methods to achieve this task: Named range + INDEX/MATCH + linked picture Chart fill + #N/A VBA User-Defined Function Each solution Read More

Get file name of current workbook thumb

Get the file name of the current workbook

There are times in Excel when we may want to display or use the file name of the current workbook, or maybe the name of a specific worksheet.  Whilst there are a variety of options none of them are particularly obvious.  This post will consider some of the possible options: Header/Footer section CELL Function VBA Read More

Change number format based on value

Change number format based on a cells value

Imagine a situation where you have built a dynamic report or dashboard that you a really proud of.  The user can make selections from a drop-down box and the report updates automatically, it’s a beautiful thing.  There is just one issue with these types of dynamic reports/dashboards – not all the information is of the Read More