I used both the Large() and Index/Match functions to find the top 5 largest and its corresponding names. The problem is when the top value are the same for two different names it repeats the name twice. See setup below:
Name Sales
================
Jim 100
Jake 75
Joe 100
Jill 50
Jason 45
John 35
Large function will list both 100 but Index will return Jim twice...any ideas? Thank you.
Bookmarks