Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

Applying dates to normalised data in Excel

Posted 19th July 2015

No comments

Use this formula to apply dates to all variables in a normalised linear list data set in Excel.

Read the full story...

VBA: List all formulae in an Excel workbook

Posted 2nd July 2015

1 comment

Described is a convenient method for using VBA scripts to extract every formula from a Microsoft Excel workbook and create a list of them in a separate sheet for later reference or backup.

Read the full story...

Easily generate Code 128 barcodes in Excel

Posted 29th May 2015

69 comments

This simple methodology can be employed to reliably generate Code 128 barcodes in Excel.

Read the full story...

Combining R1C1 and A1-style cell referencing in Excel

Posted 11th May 2015

3 comments

Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.

Read the full story...

INDEX MATCH instead of VLOOKUP

Posted 22nd January 2015

1 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...

Automatically add columns and formulae then fill-down in Excel

Posted 21st January 2015

5 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...

VLOOKUP in Excel with multiple criteria

Posted 3rd December 2014

No comments

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

Read the full story...

Sum of Column B, based on values in Column A

Posted 28th November 2014

No comments

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

Read the full story...

PowerShell logo

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

Posted 24th September 2014

9 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...

Open and close Excel workbooks in the background

Posted 4th September 2014

2 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...