I have been putting off blogging about this topic because it’s unwieldy to explain and involves work done many years ago that I would do better now. I cringe a bit seeing an Offset formula now which I would only…
Tag: MATCH
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…
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…
Top