Make Using Tables your New Year’s Resolution

Well it’s the Boxing Day holiday here in Aussieland and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day.  Fantastic stuff.  But also, this is the time of the year to think

Tagged with: , , , , , ,

INDEX, What’s the big deal?

The big deal is the INDEX formula is simply AWESOME!  Put it together with MATCH and you have an even powerful formula which I call the INDEX + MATCH combo.  Any budding data analysts out there I urge you to

Tagged with:

Transposing Data with INDEX

OK imagine this – you have done the right thing as a budding data analyst and created your sales data down the page so that you can take advantage of Pivot Tables which likes dimensions of data going across in

Tagged with: , , , , , ,

Why I like INDEX / MATCH combo (and not VLOOKUP)

Somewhere along the line I realised I was better off using what I call the INDEX / MATCH combo in nearly all lookup situations and not the ever popular VLOOKUP.  The INDEX /MATCH combo can look left and right (unlike

Tagged with: , , ,