Skip to content

{ Author Archives }

Creating Dynamic Named Ranges in Excel® using OFFSET & COUNTA

Following on from Creating Named Ranges in Excel®, this blog post describes how to create dynamic named ranges. If you’re not familar with named ranges, I’d really suggest google searching “named ranges in excel” or read the post linked to above. As mentioned many times on this site, named ranges are really useful, however there […]

Share
Tagged , , ,

Creating Named Ranges in Excel®

Named ranges are great. They allow the user to define a cell range with a single text-descriptor. For example, you could define the cell range of $A$1:$G$1 as the string “headings” and every time you wanted to refer to that cell range (in, say, a formula) you use the string “headings” instead. I’ve alluded to […]

Share
Tagged ,

Increasing your virtual memory (paging file) with Windows XP

In many operating systems you can use free disk space (which is typically in a abundance) to emulate RAM. It’s obviously not as beneficial as physically adding more RAM to your machine, however here is a brief guide to customising your virtual memory configuration using Windows XP. – Press the Windows Key + Pause|Break key […]

Share
Tagged , ,

A comprehensive how-to set up a wireless network (securely) with Windows XP guide

I wrote this how-to guide a while back, however thought I would publish it on my blog in response to: Stop Internet Poachers from Stealing Your Wi-Fi by Rick Broida. My advice to people is diametrically opposed to Rick’s, so hopefully between the two there’s a solution that best meets your requirements 🙂 Disclaimer: This […]

Share
Tagged , , ,

The weighing twelve (12) balls riddle – which one is a different weight?

This is a riddle that a friend (Carl “Chunky” Benson) put to me a few years back. A few A4 pages of scribblings and I had accounted for an “answer” for almost all possible outcomes (almost), however, I never arrived at a complete solution. There’s every chance that I’m just hopeless at Maths, so prove […]

Share
Tagged

Matching data in a table in Excel® using INDEX and MATCH – a VLOOKUP alternative

This post describes how you can use the INDEX() and MATCH() functions to look up data in a matrix. Background to VLOOKUP() Many users are familar with the VLOOKUP() (vertical lookup) function that simply looks up a value in the leading column of a table and returns the value in another specified column of the […]

Share
Tagged