Update frequency around here is not impressive, the Poorhouse knows. He's mainly been trapped behind a sea of Excel for a few millenia so it feels. In which case, let's liven things up, by discussing...Excel.
Whoop. Yep, here's a handy tip of something used in recent days. Not original or mindblowing but handy if you don't already know it.
No spreadsheet is complete without a few formulae to manipulate those magic numbers. A formula usually looks like "=A1 + A2" to add the contents of cells A1 and A2. But what if you don't know, at the point of writing your spreadsheet, exactly what cell you want to use? Rather, you want the cell used to vary depending on what has been input in another cell. There are a few different ways, but a quick, easy and perhaps dirty - albeit VBA free - one is utilising the wonders of INDIRECT.

Recent comments
1 year 17 weeks ago
1 year 21 weeks ago
1 year 22 weeks ago
1 year 22 weeks ago
1 year 22 weeks ago
1 year 22 weeks ago
1 year 22 weeks ago
1 year 23 weeks ago
1 year 23 weeks ago
1 year 23 weeks ago