confused in Frankfurt
Board Regular
- Joined
- Oct 11, 2010
- Messages
- 53
Hi There,
I have a problem I need to not only return the highest value per sales rep but the name of the deal.
<tbody>
</tbody>
<tbody>
</tbody>
The following formula returns the highest deal in the portfolio but how to get the name of the deal is the problem.
=MAXA(if('Pipeline SF '!H:H=Highlights!$B60;'Pipeline SF '!AI:AI;0))
Regards
Sarah
I have a problem I need to not only return the highest value per sales rep but the name of the deal.
Opportunity Name | Opportunity Owner | Unique Sales Price |
Arriva_Mittelstand | Andrea Junge | 130.000 |
Siemens-CIT-ARIS Design Server | Denis Wachsmuth | 17.600 |
Telefónica Alfabet | Dirk Klimas | 500.000 |
DB Systel_Terminalemulation | Andrea Junge | 800.000 |
<tbody>
</tbody>
<tbody>
</tbody>
The following formula returns the highest deal in the portfolio but how to get the name of the deal is the problem.
=MAXA(if('Pipeline SF '!H:H=Highlights!$B60;'Pipeline SF '!AI:AI;0))
Regards
Sarah