Spreadsheet: 692583d1598447934-randbetween-function-with-conditions-qc-distribution2
Sheet: Feuil1

 |  |  | I have a list of cases B4:B1003 with corresponding owners C4:C1003, few rows are empty (different numbers of cases each month). For quality check, I want to assign 10% of total number of cases (I2) to 5 team members. The team members must not review their own cases (column C), they should not review a case already assigned to another team member and there must not be a duplicate in the total list of cases to be reviewed.  I tryed with index, randbetween, coutifs, rank... I am a bit lost and need your help because using a large amount of case I get some mistakes (duplicates or case assigned to the owner for review)
 | Monthly list of cases |  |  | Cases to be reviewed by |  |  | Total =
 | Case reference | Owner |  | User 1 | User 2 | User 3 | User 4 | User 5
 | EMEA20-00931 | User 1
 | EMEA20-00932 | User 2
 | EMEA20-00933 | User 3
 | EMEA20-00934 | User 4
 | EMEA20-00935 | User 5
 | EMEA20-00936 | User 6
 | EMEA20-00937 | User 7
 | EMEA20-00938 | User 8
 | EMEA20-00939 | User 9
 | EMEA20-00941 | User 10
 | EMEA20-00942 | User 1
 | EMEA20-00943 | User 2
 | EMEA20-00944 | User 3
 | EMEA20-00945 | User 4
 | EMEA20-00946 | User 5
 | EMEA20-00947 | User 6
 | EMEA20-00948 | User 7
 | EMEA20-00949 | User 8
 | EMEA20-00950 | User 9
 | EMEA20-00951 | User 10
 | EMEA20-00952 | User 1
 | EMEA20-00953 | User 2
 | EMEA20-00954 | User 3
 | EMEA20-00955 | User 4
 | EMEA20-00956 | User 5
 | EMEA20-00957 | User 6
 | EMEA20-00958 | User 7
 | EMEA20-00959 | User 8
 | EMEA20-00960 | User 9
 | EMEA20-00961 | User 10
 | EMEA20-00962 | User 1
 | EMEA20-00963 | User 2
 | EMEA20-00964 | User 3
 | EMEA20-00965 | User 4
 | EMEA20-00966 | User 5
 | EMEA20-00967 | User 6
 | EMEA20-00968 | User 7
 | EMEA20-00969 | User 8
 | EMEA20-00970 | User 9
 | EMEA20-00971 | User 10
 | EMEA20-00972 | User 1
 | EMEA20-00973 | User 2
 | EMEA20-00974 | User 3
 | EMEA20-00975 | User 4
 | EMEA20-00976 | User 5
 | EMEA20-00977 | User 6
 | EMEA20-00978 | User 7
 | EMEA20-00979 | User 8
 | EMEA20-00980 | User 9
 | EMEA20-00981 | User 10
 | EMEA20-00982 | User 1
 | EMEA20-00983 | User 2
 | EMEA20-00984 | User 3
 | EMEA20-00985 | User 4
 | EMEA20-00986 | User 5
 | EMEA20-00987 | User 6
 | EMEA20-00988 | User 7
 | EMEA20-00989 | User 8
 | EMEA20-00990 | User 9
 | EMEA20-00991 | User 10
 | EMEA20-00992 | User 1
 | EMEA20-00993 | User 2
 | EMEA20-00994 | User 3
 | EMEA20-00995 | User 4
 | EMEA20-00997 | User 5
 | EMEA20-00998 | User 6
 | EMEA20-00999 | User 7
 | EMEA20-01000 | User 8
 | EMEA20-01001 | User 9
 | EMEA20-01004 | User 10
 | EMEA20-01005 | User 1
 | EMEA20-01006 | User 2
 | EMEA20-01007 | User 3
 | EMEA20-01009 | User 4
 | EMEA20-01010 | User 5
 | EMEA20-01011 | User 6
 | EMEA20-01012 | User 7
 | EMEA20-01014 | User 8
 | EMEA20-01015 | User 9
 | EMEA20-01016 | User 10
 | EMEA20-01017 | User 1
 | EMEA20-01018 | User 2
 | EMEA20-01019 | User 3
 | EMEA20-01020 | User 4
 | EMEA20-01021 | User 5
 | EMEA20-01022 | User 6
 | EMEA20-01023 | User 7
 | EMEA20-01024 | User 8
 | EMEA20-01025 | User 9
 | EMEA20-01026 | User 10
 | EMEA20-01027 | User 1
 | EMEA20-01028 | User 2
 | EMEA20-01029 | User 3
 | EMEA20-01030 | User 4
 | EMEA20-01031 | User 5
 | EMEA20-01032 | User 6
 | EMEA20-01033 | User 7