I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...
That all changed when I discovered two features in Excel most people don't know about: Watch Window and Custom Views. Together, they provided me with a way to track the numbers that matter without ...