I'm trying to figure out if there is a way to have a repeating list/order in a particular column that changes once specific criteria are met. For purposes of illustration, I am attaching a sample spreadsheet. The idea is that the letters in column A stand for individual salespeople. Column B says whether they were successful in making a sale in a given attempt. I would like column A to repeat their letters in that order but once each salesperson makes 3 sales, that particular salesperson should be removed from the order in column A going forward while the rest of the salespeople remain until they each have completed 3 sales. Please let me know if that isn't clear. I started a solution using dummy columns and COUNTIFS functions, but I'm not sure how to bring it home with what I figure should be a formula for each cell in column A. Any help would be much appreciated.Test Worksheet.xls