Hi,
Here is a sample data set :
Sales Rep Amount
Julian 1000
Matt 2000
Matt 2000
Julian 5000
Steph 3500
I'm trying to find say the top 2 sales rep. So the end result would be :
1. Julian 6000
2. Matt 4000
I'm pretty sure I need to be using the LARGE function in an array but not quite sure how to get the rest done. Any ideas ?
Thanks !
Bookmarks