Skip to content
excel-logo-2013

VLOOKUP in Excel with multiple criteria

G3rd December 2014 

CNo comments

An alternative to VLOOKUP in Excel that permits a search based on multiple criteria.

Read the full story

excel-logo-2013

Sum of Column B, based on values in Column A

G28th November 2014 

CNo comments

Use an array formula to calculate selected values in one column, based on parameters in another.

Read the full story

power-shell

Automatically delete files listed in a CSV

G26th September 2014 

CNo comments

A PowerShell script that reads a list of files in a CSV and deletes them from a computer drive automatically.

Read the full story

google-chrome

Fix the ‘Gill Sans’ font bug in Chrome

G25th September 2014 

C2 comments

Bug fix: A quick CSS remedy to ensure that Google Chrome 37 displays the Gill Sans font correctly.

Read the full story

power-shell

Script to list image files by size and resolution, export to Excel

G24th September 2014 

CNo comments

Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.

Read the full story

excel-logo-2013

Open and close Excel workbooks in the background

G4th September 2014 

CNo comments

Use a Visual Basic for Applications (VBA) script to open secondary Excel workbooks as data sources when opening a VLOOKUP-dependent workbook.

Read the full story

excel-logo-2013

Round to the nearest work day in Excel

G31st July 2014 

CNo comments

Use this basic formula to round any scheduled date to the next working day (Monday to Friday) for use in workplace task planning.

Read the full story

excel-logo-2013

Automatically update Pivot Tables in Excel

G15th July 2014 

CNo comments

A simple VBA script that refreshes (updates) all Pivot Tables within an Excel workbook after any change to a worksheet.

Read the full story

excel-logo-2013

Add a suffix to selected cells in Excel

G12th July 2014 

CNo comments

Use this handly VBA macro to automatically add characters to the end of values in a selected range of cells.

Read the full story

silverstripe-logo

Upgrading Silverstripe 3.1.x

G5th July 2014 

C1 comment

Instructions for upgrading an installation of SilverStripe 3.1.x to the latest version.

Read the full story