Hi I have some data below and from the data I want: 1. A maximum of 6 records per customer 2. From the 6 records I want on only record from Pet and one from Home if in rank 1 to 6 and then the remainder to be Food. However, if Home and Pet are not in rank 1 to 6 for each customer group then just select Food even though rank 7 could be Home or Pet(See cust_ID C as what I mean by this) Also not all customers will have a max of 6 records, some might have five (see cust_id b as the example). I have highlighted in red which records I want selected using the above logic Thanks Cust_ID Rank Group A 1 FOOD A 2 PET A 3 PET A 4 HOME A 5 FOOD A 6 FOOD A 7 FOOD A 8 FOOD B 1 PET B 2 FOOD B 3 PET B 4 FOOD B 5 FOOD C 1 FOOD C 2 FOOD C 3 FOOD C 4 FOOD C 5 FOOD C 6 FOOD C 7 PET C 8 HOME
... View more