Skip to content
excel-logo-2013

INDEX MATCH instead of VLOOKUP

G22nd January 2015 

C1 comment

INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.

Read the full story

excel-logo-2013

Automatically add columns and formulae then fill-down in Excel

G21st January 2015 

CNo comments

Some simple VBA code to add columns in Excel, insert specific formulae at the top then fill-down to the bottom of the sheet.

Read the full story

silverstripe-logo

Adding search to SilverStripe

G3rd January 2015 

CNo comments

Whilst it’s relatively easy to add a site search function to SilverStripe, quite a bit of tweaking is required to make it perform as it should. Here are some simple instructions.

Read the full story

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