Hello All!
I need your help again, please. Have a problem with finding maximum and minimum in my data table.
I'd like to find the best and worst workers from the table based on their performance and supervisor.
I managed to write a formula for the best and worst based on performance only:
=Index(B4:B23,Match(Max(L4:L23),L4:L23,0),)
Is there any way to get that for specific SV?
I attached a sample file. Thank you in advance!
Bookmarks