View Single Post
  #1   Report Post  
Jim Gentile
 
Posts: n/a
Default finding highest dollar amount

I would like a formula that will draw out of a list of sales people and their
sales the top sale and who that person is:

For example if these are my sales:

Brian 72.9
Brian 104.77
Brian 119.99
Brian 229.97
Brian 142.84
Brian 259.87
Cassi 301.95
Cassi 62.9
Cassi 49.95
Cassi 139
Chad 94.99
Chad 76.9
Chris 283.98
Chris 34.95
Chris 133.97
Chris 249.99
Chris 1499.87
Clarissa 98.85
Clarissa 125.95
Clarissa 62.9


I would like the formula to draw out Chris in one cell and $1499.87 in the
cell next to his name.

Thanks for your help.