A bit of a follow up from the earlier post on highlighting negative values. This should work with all versions on Excel – though the options may be in slightly different places. This time, I want to highlight the measure with the single highest value. I’m going to use the same chart as before. So, IRead More
One of my all-time favourite Excel functions has been SUMPRODUCT – it’s versatility was endless, but was especially useful for when you wanted to SUM up some data with multiple conditions, such as sales of Pencils in the East region, perhaps. Using SUMPRODUCT, we’d have written something like this… This works well, but as anyone who hasRead More
