Hi,
I am having an issue.
I need to create a (or 3) function to find the top three values, in order, and return values from ther columns. For example:
A B C
pa 1 rj
re 8 sp
te 9 pr
be 2 nn
yu 3 pq
The function would need to find the top 3 highest values on column B and return values from columns A and C of that row.
So, the function would return:
te 9 pr
re 8 sp
yu 3 pq
Alreaqdy thinking about a possible problem, how to deal with ties?
Many thanks!
Bookmarks