Expert Zone
Recovery tool

Exclusive articles from Ray Blake

We are glad to share these articles written exclusively for us by Ray Blake with you. Our aim is to give you an extra bonus to our OfficeFIX file repair software. We hope you will find them helpful.

Excel Lookup Functions Explained

Using VLOOKUP, HLOOKUP, INDEX, and MATCH in Excel to interrogate data tables Lookup tables are fantastically useful things in Excel. I remember when someone showed me for the first time how to build a data table and perform some simple lookups on it. For the first time, I began to realise just how powerful Excel could be in the right hands.

Excel Performance Analysis the Professional Way

Analyzing performance data in Excel using array formula and dynamic range name methods.

Beyond Excel’s Holy Grail

Moving beyond a dependence on array formulae in Excel It's something of a rite of passage, really, the day when the intermediate Excel user discovers array formulae. If you haven't got to that stage just yet, stop reading now, but keep this article handy. When you get to the point (and you will) when you can't imagine life again without array formulae, take out this article and read it.

Automatic Chart Harmonisation

Why Excel is missing a charting feature and how that feature can be recreated using VBA.

Excel formula development in the real world

Name field reconcatenation in Excel explained through building worksheet formulae and custom VBA functions.