Select the top value from the column

Frequent Visitor

Hi all excel gurus,

 

May I seek for help regarding this issue. I want to pick 20 sample from each of the person in the column(Agents) with many name. May I know is it possible to pick the top n from the column in excel so each person pick is 20 for each attribute where there also some of the feedback B has less than 10 so I want to top up the remaining of the sample with feedback a and the sample pick is ~500 when pick from all the person.

iena2_0-1646962254405.png

*This is the sample data not the actual data.

iena2_1-1646962895126.png

This is the flow from the excel that Want to achieved. Is there any formula to pick the number of agent like this. Thank you gurus

0 Replies