I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into Values. It will also be nicely formatted. However, if I change anything in ...
Excel doesn’t have a direct equivalent. To achieve the same result, you’d either have to piece together complex formulas with functions like SEARCH or write custom VBA scripts. While those approaches ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback