Spreadsheet: 817205d1676050387-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
 |  |  |  | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | 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
 |  |  |  | Betty | 13 | 9 |  | Betty | 6 | 6 |  | [NAME] | 3 | 3 |  | Doug | 14 | 9 |  | Maria | 14 | 8 |  | Betty | 13 | 9
 |  |  |  | [NAME] | 12 | 5 |  | [NAME] | 5 | 4 |  | [NAME] | 3 | 3 |  | Efrain | 13 | 8 |  | Nick | 13 | 8 |  | [NAME] | 12 | 5
 |  |  |  | Doug | 8 | 6 |  | Doug | 5 | 4 |  | Doug | 3 | 3 |  | Fran | 12 | 8 |  | [NAME] | 12 | 9 |  | Doug | 8 | 6
 |  |  |  | Efrain | 8 | 6 |  | Efrain | 4 | 4 |  | Efrain | 3 | 2 |  | Gretta | 11 | 8 |  | Paco | 11 | 9 |  | Efrain | 8 | 6
 |  |  |  | Fran | 7 | 7 |  | Fran | 4 | 3 |  | Fran | 3 | 2 |  | Ray | 10 | 4 |  | Quinten | 10 | 9 |  | Fran | 7 | 7
 |  |  |  | Gretta | 7 | 3 |  | Gretta | 4 | 3 |  | Gretta | 2 | 2 |  | Scott | 5 | 2 |  | Zia | 9 | 9 |  | Gretta | 7 | 3
 |  |  |  | Hector | 6 | 5 |  | [NAME] | 4 | 3 |  | Hector | 2 | 2 |  | [NAME] | 5 | 1 |  |  |  |  |  | Hector | 6 | 5
 |  |  |  | Icel | 5 | 5 |  | Ingrid | 3 | 3 |  | Icel | 2 | 1 |  | Ulysis | 5 | 1 |  |  |  |  |  | Icel | 5 | 5
What I Have --> |  |  |  | [NAME] | 5 | 3 |  | [NAME] | 3 | 3 |  | [NAME] | 2 | 1 |  | Vera | 5 | 1 |  |  |  |  |  | [NAME] | 5 | 3
 |  |  |  | [NAME] | 4 | 4 |  | [NAME] | 2 | 2 |  | [NAME] | 2 | 1 |  | Zia | 1 | 1 |  |  |  |  |  | [NAME] | 4 | 4
 |  |  |  | [NAME] | 4 | 3 |  | Vera | 2 | 2 |  | [NAME] | 2 | 1 |  |  |  |  |  |  |  |  |  | [NAME] | 4 | 3
 |  |  |  | Maria | 4 | 3 |  | Will | 2 | 2 |  | Maria | 1 | 0 |  |  |  |  |  |  |  |  |  | Maria | 4 | 3
 |  |  |  | Nick | 4 | 3 |  | Xavier | 2 | 0 |  | Nick | 1 | 0 |  |  |  |  |  |  |  |  |  | Nick | 4 | 3
 |  |  |  | [NAME] | 3 | 2 |  | Yancy | 1 | 0 |  | [NAME] | 1 | 0 |  |  |  |  |  |  |  |  |  | [NAME] | 3 | 2
 |  |  |  | Paco | 3 | 1 |  | Zia | 1 | 0 |  | Paco | 1 | 0 |  |  |  |  |  |  |  |  |  | Paco | 3 | 1
 |  |  |  | Quinten | 2 | 2 |  |  |  |  |  | Quinten | 1 | 0 |  |  |  |  |  |  |  |  |  | Quinten | 2 | 2
 |  |  |  | Ray | 2 | 1 |  |  |  |  |  | Zia | 1 | 0 |  |  |  |  |  |  |  |  |  | Ray | 2 | 1
 |  |  |  | Scott | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scott | 2 | 1
 |  |  |  | [NAME] | 2 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 0
 |  |  |  | Ulysis | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ulysis | 1 | 1
 |  |  |  | Vera | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vera | 1 | 1
 |  |  |  | Will | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Will | 1 | 1
 |  |  |  | Xavier | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Xavier | 1 | 1
 |  |  |  | Yancy | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yancy | 1 | 1
 |  |  |  | Zia | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zia | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Week 1-3 |  |  |  | Week 2-4 |  |  |  | Week 3-5 |  |  |  | Week 4-6
 |  |  |  |  |  |  |  |  |  |  |  | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success % | Rep | Count | Positives | Success %
 |  |  |  |  |  |  |  | Starting at Week 3 (M32), I need to |  |  |  | [NAME] | 21 | 16 |  | [NAME] | 23 | 18
 |  |  |  |  |  |  |  | combine Week 1, 2, & 3 |  |  |  | [NAME] | 20 | 12 |  | Doug | 22 | 16
 |  |  |  |  |  |  |  | showing only Unique values, sorted |  |  |  | Betty | 19 | 15 |  | Efrain | 20 | 14
 |  |  |  |  |  |  |  | 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