I have data having multiple groups and from time to time I am being asked to get top or bottom candidate from each group. Presently I have to do it manually for each group.
Is there a way to make this process automated??
Example of data set