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.


*This is the sample data not the actual data.


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