I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...
From spreadsheets to showdowns, the Excel World Championship turns number-crunching into a high-stakes spectacle.
To apply the dollar currency to a value, select the cell, press Ctrl+1 to launch the Format Cells dialog box, and select "Currency" or "Accounting" in the Number tab. Then, choose the dollar symbol ...