Using VLOOKUP on multiple items and how to split text strings
How to apply VLOOKUP to many cells and add the results. How to split text cells into columns
top of page
Search
Miles Goodchild
Feb 15, 20221 min read
Use Excel custom formats to show emoji and text
How to use Custom Formats to change the colour of the cell, display an emoji or add text depending on the cell's contents.
127 views0 comments
Miles Goodchild
Feb 15, 20222 min read
The 56 standard colours in Excel - the ColorIndex values or pallet
Whilst you can use conditional formatting and cell fill etc. to give you almost any colour in excel there is a "special" set of 56...
544 views0 comments
Miles Goodchild
Dec 6, 20211 min read
How to display a cell’s colour in Excel
It is not possible to directly access the colour of a cell in an Excel worksheet. Thus you can not write an expression such as “if the...
26 views0 comments
Miles Goodchild
Dec 5, 20212 min read
An easy way to make fully dynamic related drop-down boxes
In previous blog posts, we have seen how to make drop-down boxes driven by the entries in other cells and drop-down boxes. In this blog,...
4 views0 comments
Miles Goodchild
Nov 16, 20212 min read
How to produce a list of weekdays
How to display only weekdays in excel - three simple methods.
11 views0 comments
Miles Goodchild
Nov 15, 20211 min read
How to make many levels of dependent drop-down boxes
In the blog Excel – How To Make A Drop-Down Dependent On Another Drop-Down, I showed how to make the contents of a drop-down box...
7 views0 comments
Miles Goodchild
Nov 15, 20211 min read
How to make a dynamic drop-down box
In the blog (Excel – How To Make A Drop-Down Dependent On Another Drop-Down), I showed how to make the contents of a drop-down box...
2 views0 comments
Miles Goodchild
Nov 9, 20212 min read
Excel – how to make a drop-down dependent on another drop-down
Sometimes in Excel you want to make a selection dependent on another choice. For instance, you would like to select a country from a...
5 views0 comments
Miles Goodchild
Nov 8, 20212 min read
Automatically pulling data from other sheets into a dashboard
Situation A client had a single worksheet per project and wanted to pull data from each sheet into a single dashboard to give a view...
8 views0 comments
Miles Goodchild
Oct 12, 20214 min read
How to convert an Excel Gantt chart into an MS Project plan
How to convert a Gantt in Excel into a Project Plan in MS Project. Simple step by step instructions to automate the process and avoid error
71 views1 comment
Miles Goodchild
Jun 14, 20215 min read
How to produce a personalised week ahead report from MS Project
In this blog you will learn how to filter a project or programme plan to show the tasks ahead which have been assignefd to a specific...
6 views0 comments
Miles Goodchld
Jun 8, 20214 min read
Working with Cell Colour, tint and shades in Excel VBA
How to use VBA to get the RGB colour for a cell and then adjust this colour by changing the shade or tint. Then colour another cell.
1,904 views0 comments
bottom of page