Master Excel percentages with expert hacks to save time, reduce errors, and boost confidence in your data. Learn shortcuts ...

let's say your aim is to find out which counties are attracting the greatest percentage of sales. Because GROUPBY creates a dynamic array, the function won't work in a formatted Excel table.