Here is what i am trying to accomplish.
I am needed to find the highest 3 values in a range of cells using LARGE. Example:
NAME DOLLARS
________________
Pat 2112.00
Rick 114.00
Greg 1889.00
Now, I would like to populate on another sheet with the top 3 being displayed in order. Example:
NAME DOLLARS
________________
Pat 2112.00
Greg 1889.00
Rick 114.00
Now the problem i am having is that I can easily populate the dollars collum however, how to i take the data from the Name collumn associated with the their respective dollars?
Bookmarks