I recently wrote a post on the excelpivots site showing how you can use pivot tables to compare data without resorting to the inferior VLOOKUP method.
Catchy title I think you’ll agree - GETPIVOTDATA click bait if ever I saw it…
Today I am processing data from a patient level costing system (PLiCS) and trying to assess the cost distribution by the patients diagnosis.
Since we’ve moved to excel 2010 with its expanded data range the tendency has been to create ever more detailed reports. Where once we summarised data we can now leave in every last bit of detail.