Read options in more than one cell
If the A column lists the salespersons name, and the B column lists their
sales. I would like a formula that will total all individuals sales, and
then list the top sales in a separate cell, with the name of that salesperson
in the cell next to the totaled sales.
For example: based on the numbers below, I would like Amber to appear in D1
and $297.69 to appear in E1. Thanks for your help.
Amber $158.69
Amber $139.00
Beverly $139.87
Beverly $41.90
Beverly $73.97
Beverly $24.95
Blase $64.99
Blase $208.98
|