Spreadsheet: 817234d1676064173-finding-unique-data-and-sorting-across-multiple-columns-unique-and-sort-multiple-columns
Sheet: Sheet1

Sensitive Data |  |  |  | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5 |  |  |  | Week 6 |  |  |  |  | Week 1, 2, & 3 |  |  |  | Week 2, 3, & 4 |  |  |  | Week 3, 4, & 5 |  |  |  | Week 4, 5, & 6
 |  |  |  | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % |  |  | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success %
 |  |  |  | [NAME] | 14 | 9 |  | [NAME] | 7 | 7 |  | [NAME] | 4 | 3 |  | [NAME] | 15 | 11 |  | [NAME] | 15 | 14 |  | [NAME] | 14 | 9 |  |  | [NAME] | 21 | 16 | 0.7619047619047619 | [NAME] | 23 | 18 | 0.782608695652174 | [NAME] | 18 | 14 | 0.7777777777777778 | [NAME] | 27 | 16 | 0.5925925925925926
 |  |  |  | Betty | 13 | 9 |  | Betty | 6 | 6 |  | [NAME] | 3 | 3 |  | Doug | 14 | 9 |  | Maria | 14 | 8 |  | Betty | 13 | 9 |  |  | [NAME] | 20 | 12 | 0.6 | Doug | 22 | 16 | 0.7272727272727273 | [NAME] | 17 | 15 | 0.8823529411764706 | Doug | 22 | 15 | 0.6818181818181818
 |  |  |  | [NAME] | 12 | 5 |  | [NAME] | 5 | 4 |  | [NAME] | 3 | 3 |  | Efrain | 13 | 8 |  | Nick | 13 | 8 |  | [NAME] | 12 | 5 |  |  | Betty | 19 | 15 | 0.7894736842105263 | Efrain | 20 | 14 | 0.7 | Doug | 17 | 12 | 0.7058823529411765 | Efrain | 21 | 14 | 0.6666666666666666
 |  |  |  | Doug | 8 | 6 |  | Doug | 5 | 4 |  | Doug | 3 | 3 |  | Fran | 12 | 8 |  | [NAME] | 12 | 9 |  | Doug | 8 | 6 |  |  | Doug | 16 | 13 | 0.8125 | Fran | 19 | 13 | 0.6842105263157895 | Efrain | 16 | 10 | 0.625 | [NAME] | 19 | 17 | 0.8947368421052632
 |  |  |  | Efrain | 8 | 6 |  | Efrain | 4 | 4 |  | Efrain | 3 | 2 |  | Gretta | 11 | 8 |  | Paco | 11 | 9 |  | Efrain | 8 | 6 |  |  | Efrain | 15 | 12 | 0.8 | Gretta | 17 | 13 | 0.7647058823529411 | Fran | 15 | 10 | 0.6666666666666666 | Fran | 19 | 15 | 0.7894736842105263
 |  |  |  | Fran | 7 | 7 |  | Fran | 4 | 3 |  | Fran | 3 | 2 |  | Ray | 10 | 4 |  | Quinten | 10 | 9 |  | Fran | 7 | 7 |  |  | Fran | 14 | 12 | 0.8571428571428571 | Ray | 10 | 4 | 0.4 | Maria | 15 | 8 | 0.5333333333333333 | Gretta | 18 | 11 | 0.6111111111111112
 |  |  |  | Gretta | 7 | 3 |  | Gretta | 4 | 3 |  | Gretta | 2 | 2 |  | Scott | 5 | 2 |  | Zia | 9 | 9 |  | Gretta | 7 | 3 |  |  | Gretta | 13 | 8 | 0.6153846153846154 | [NAME] | 7 | 7 | 1 | Nick | 14 | 8 | 0.5714285714285714 | Maria | 18 | 11 | 0.6111111111111112
 |  |  |  | Hector | 6 | 5 |  | [NAME] | 4 | 3 |  | Hector | 2 | 2 |  | [NAME] | 5 | 1 |  |  |  |  |  | Hector | 6 | 5 |  |  | Hector | 8 | 7 | 0.875 | Vera | 7 | 3 | 0.4285714285714285 | Gretta | 13 | 10 | 0.7692307692307693 | Nick | 17 | 11 | 0.6470588235294118
 |  |  |  | Icel | 5 | 5 |  | Ingrid | 3 | 3 |  | Icel | 2 | 1 |  | Ulysis | 5 | 1 |  |  |  |  |  | Icel | 5 | 5 |  |  | Icel | 7 | 6 | 0.8571428571428571 | Betty | 6 | 6 | 1 | [NAME] | 13 | 9 | 0.6923076923076923 | [NAME] | 15 | 11 | 0.7333333333333333
What I Have --> |  |  |  | [NAME] | 5 | 3 |  | [NAME] | 3 | 3 |  | [NAME] | 2 | 1 |  | Vera | 5 | 1 |  |  |  |  |  | [NAME] | 5 | 3 |  |  | [NAME] | 7 | 4 | 0.5714285714285714 | Scott | 5 | 2 | 0.4 | Paco | 12 | 9 | 0.75 | Paco | 14 | 10 | 0.7142857142857143
 |  |  |  | [NAME] | 4 | 4 |  | [NAME] | 2 | 2 |  | [NAME] | 2 | 1 |  | Zia | 1 | 1 |  |  |  |  |  | [NAME] | 4 | 4 |  |  | [NAME] | 6 | 5 | 0.8333333333333334 | [NAME] | 5 | 1 | 0.2 | Zia | 11 | 10 | 0.9090909090909091 | [NAME] | 14 | 9 | 0.6428571428571429
 |  |  |  | [NAME] | 4 | 3 |  | Vera | 2 | 2 |  | [NAME] | 2 | 1 |  |  |  |  |  |  |  |  |  | [NAME] | 4 | 3 |  |  | [NAME] | 6 | 4 | 0.6666666666666666 | Ulysis | 5 | 1 | 0.2 | Quinten | 11 | 9 | 0.8181818181818182 | Betty | 13 | 9 | 0.6923076923076923
 |  |  |  | Maria | 4 | 3 |  | Will | 2 | 2 |  | Maria | 1 | 0 |  |  |  |  |  |  |  |  |  | Maria | 4 | 3 |  |  | Maria | 5 | 3 | 0.6 | [NAME] | 4 | 3 | 0.75 | Ray | 10 | 4 | 0.4 | Quinten | 12 | 11 | 0.9166666666666666
 |  |  |  | Nick | 4 | 3 |  | Xavier | 2 | 0 |  | Nick | 1 | 0 |  |  |  |  |  |  |  |  |  | Nick | 4 | 3 |  |  | Nick | 5 | 3 | 0.6 | [NAME] | 4 | 3 | 0.75 | Scott | 5 | 2 | 0.4 | Ray | 12 | 5 | 0.4166666666666667
 |  |  |  | [NAME] | 3 | 2 |  | Yancy | 1 | 0 |  | [NAME] | 1 | 0 |  |  |  |  |  |  |  |  |  | [NAME] | 3 | 2 |  |  | [NAME] | 4 | 3 | 0.75 | Ingrid | 3 | 3 | 1 | [NAME] | 5 | 1 | 0.2 | Zia | 11 | 11 | 1
 |  |  |  | Paco | 3 | 1 |  | Zia | 1 | 0 |  | Paco | 1 | 0 |  |  |  |  |  |  |  |  |  | Paco | 3 | 1 |  |  | [NAME] | 4 | 3 | 0.75 | [NAME] | 3 | 3 | 1 | Ulysis | 5 | 1 | 0.2 | Scott | 7 | 3 | 0.4285714285714285
 |  |  |  | Quinten | 2 | 2 |  |  |  |  |  | Quinten | 1 | 0 |  |  |  |  |  |  |  |  |  | Quinten | 2 | 2 |  |  | [NAME] | 4 | 2 | 0.5 | [NAME] | 3 | 3 | 1 | Vera | 5 | 1 | 0.2 | [NAME] | 7 | 1 | 0.1428571428571428
 |  |  |  | Ray | 2 | 1 |  |  |  |  |  | Zia | 1 | 0 |  |  |  |  |  |  |  |  |  | Ray | 2 | 1 |  |  | Paco | 4 | 1 | 0.25 | Zia | 3 | 1 | 0.3333333333333333 | [NAME] | 4 | 3 | 0.75 | Hector | 6 | 5 | 0.8333333333333334
 |  |  |  | Scott | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scott | 2 | 1 |  |  | Vera | 3 | 3 | 1 | [NAME] | 2 | 2 | 1 | [NAME] | 3 | 3 | 1 | Ulysis | 6 | 2 | 0.3333333333333333
 |  |  |  | [NAME] | 2 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 0 |  |  | Will | 3 | 3 | 1 | Will | 2 | 2 | 1 | Hector | 2 | 2 | 1 | Vera | 6 | 2 | 0.3333333333333333
 |  |  |  | Ulysis | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ulysis | 1 | 1 |  |  | Ingrid | 3 | 3 | 1 | Hector | 2 | 2 | 1 | Icel | 2 | 1 | 0.5 | Icel | 5 | 5 | 1
 |  |  |  | Vera | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vera | 1 | 1 |  |  | [NAME] | 3 | 3 | 1 | Icel | 2 | 1 | 0.5 | [NAME] | 2 | 1 | 0.5 | [NAME] | 5 | 3 | 0.6
 |  |  |  | Will | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Will | 1 | 1 |  |  | [NAME] | 3 | 3 | 1 | [NAME] | 2 | 1 | 0.5 | [NAME] | 2 | 1 | 0.5 | [NAME] | 4 | 4 | 1
 |  |  |  | Xavier | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Xavier | 1 | 1 |  |  | Quinten | 3 | 2 | 0.6666666666666666 | [NAME] | 2 | 1 | 0.5 |  |  |  |  | Will | 1 | 1 | 1
 |  |  |  | Yancy | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yancy | 1 | 1 |  |  | Xavier | 3 | 1 | 0.3333333333333333 | [NAME] | 2 | 1 | 0.5 |  |  |  |  | Xavier | 1 | 1 | 1
 |  |  |  | Zia | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zia | 1 | 1 |  |  | Zia | 3 | 1 | 0.3333333333333333 | Xavier | 2 | 0 | 0 |  |  |  |  | Yancy | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 2 | 1 | Yancy | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Week 1-3 |  |  |  | Week 2-4 |  |  |  | Week 3-5 |  |  |  | Week 4-6 |  |  |  |  | Ray | 2 | 1 | 0.5 | Maria | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % |  | Scott | 2 | 1 | 0.5 | Nick | 1 | 0 | 0
 |  |  |  |  |  |  |  | Starting at Week 3 (M32), I need to |  |  |  | [NAME] | 21 | 16 |  | [NAME] | 23 | 18 |  |  |  |  |  |  |  |  |  |  | Yancy | 2 | 1 | 0.5 | [NAME] | 1 | 0 | 0
 |  |  |  |  |  |  |  | combine Week 1, 2, & 3 |  |  |  | [NAME] | 20 | 12 |  | Doug | 22 | 16 |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 0 | 0 | Paco | 1 | 0 | 0
 |  |  |  |  |  |  |  | showing only Unique values, sorted |  |  |  | Betty | 19 | 15 |  | Efrain | 20 | 14 |  |  |  |  |  |  |  |  |  |  | Ulysis | 1 | 1 | 1 | Quinten | 1 | 0 | 0
 |  |  |  |  |  |  |  | on Count, then Success % cols |  |  |  | Doug | 16 | 13 |  | Fran | 19 | 13
 |  |  |  |  |  |  |  | then week 4 would do the same |  |  |  | Efrain | 15 | 12 |  | Gretta | 17 | 13
 |  |  |  |  |  |  |  | but for weeks 2, 3, & 4 |  |  |  | Fran | 14 | 12 |  | Ray | 10 | 4
 |  |  |  |  |  |  |  | then Week 5 would be 3, 4, & 5 |  |  |  | Gretta | 13 | 8 |  | [NAME] | 7 | 7
 |  |  |  |  |  |  |  | Each week could have between 1 |  |  |  | Hector | 8 | 7 |  | Betty | 6 | 6
 |  |  |  |  |  |  |  | and 100 entires |  |  |  | Icel | 7 | 6 |  | Scott | 5 | 2
 |  |  |  |  |  |  |  | Never more than 100 entries in the |  |  |  | [NAME] | 7 | 4 |  | [NAME] | 5 | 1
 |  |  |  |  |  |  |  | column of combined weeks |  |  |  | [NAME] | 6 | 5 |  | Ulysis | 5 | 1
 |  |  |  |  |  |  |  | [NAME]… no VBA ALLOWED |  |  |  | [NAME] | 6 | 4 |  | Vera | 5 | 1
 |  |  |  |  |  |  |  | What I Want to Show --> |  |  |  | Maria | 5 | 3 |  | [NAME] | 4 | 3
 |  |  |  |  |  |  |  |  |  |  |  | Nick | 5 | 3 |  | [NAME] | 4 | 3
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | 3 |  | Ingrid | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | 3 |  | [NAME] | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | 2 |  | [NAME] | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  | Paco | 4 | 1 |  | Zia | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Vera | 3 | 3 |  | [NAME] | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  | Will | 3 | 3 |  | Vera | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  | Ingrid | 3 | 3 |  | Will | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 | 3 |  | Hector | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 | 3 |  | Icel | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Quinten | 3 | 2 |  | [NAME] | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Xavier | 3 | 1 |  | [NAME] | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Zia | 3 | 1 |  | [NAME] | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 2 |  | Xavier | 2 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Ray | 2 | 1 |  | Yancy | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Scott | 2 | 1 |  | Maria | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Yancy | 2 | 1 |  | Nick | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 0 |  | [NAME] | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Ulysis | 1 | 1 |  | Paco | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quinten | 1 | 0