Spreadsheet: 888928d1739549870-formula-needed-tiebreaker-excel-forum-sample-bdmt-scoresheets-need-to-add-tie-breaker
Sheet: Scenario

Sort Entry | Concatenate Paste Special Merged Columns | Score | Helper Column | Original Ranking | [NAME] | Match | Expected Results | Status x = [NAME] = Send O = Order | DIVISION | LEVEL | CATEGORY | EXP | Merged Columns Contatenate Formula | Merged Columns Paste Special | Entry | Group Name | NAMES | REGION | SONG(S) | [NAME] | Date and Time | [NAME] | [NAME] | [NAME] | J-1  Proy | [NAME] | [NAME] | [NAME] | [NAME] | J-1 Autent | J-1 Tie Breaker | JUDGE #1 TOTAL | [NAME] | [NAME] | [NAME] | J-1  Proy | [NAME] | [NAME] | [NAME] | [NAME] | J-1 Autent | J-1 Tie Breaker | JUDGE #2 TOTAL | [NAME] | [NAME] | [NAME] | J-1  Proy | [NAME] | [NAME] | [NAME] | [NAME] | J-1 Autent | J-1 Tie Breaker | JUDGE #3 TOTAL | SCORE | Tie Breaker Category Added Together
682 | 01-P/NP01-YC01-Solo01-Beg. | 100 | Division 1 |  |  |  | 2 |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 01-P/NP01-YC01-Solo01-Beg. | 38-16 | Houston Ballet Folklorico |  | [NAME] | El Gallito | Conf Room | 2025-02-14 20:56:00 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 20
438 | 01-P/NP01-YC01-Solo01-Beg. | 100 | Division 1 |  |  |  | 1 |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 01-P/NP01-YC01-Solo01-Beg. | 17-01 | Ballet [NAME] | Alexa Soto | Baja California Norte | Las Florecitas | Conf Room | 2025-02-15 14:36:00 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 21
724 | 01-P/NP01-YC01-Solo01-Beg. | 90 | Division 1 |  |  |  | 3 |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 01-P/NP01-YC01-Solo01-Beg. | 42-02 | [NAME] | [NAME] | Jalisco | La Vaquilla | Conf Room | 2025-02-15 19:28:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
542 | 01-P/NP01-YC01-Solo01-Beg. | 80 | Division 1 |  |  |  | 4 |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 01-P/NP01-YC01-Solo01-Beg. | 24-09 | Compañia Folklorica Alegria Mexicana | [NAME] | [NAME] | Cerro de la Silla | Conf Room | 2025-02-15 22:08:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
92 | 01-P/NP01-YC01-Solo01-Beg. | 70 | Division 1 |  |  |  | 5 |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 01-P/NP01-YC01-Solo01-Beg. | 04-09 | [NAME] | [NAME] | Chiapas | El Rito | Conf Room | 2025-02-16 10:24:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  | 01-P/NP01-YC01-Solo01-Beg. Count
2 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 01-02 | Academy of Folklore & Latin Rhythms | [NAME] | Sinaloa | El Coyote | Conf Room | 2025-02-14 15:48:00
3 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 01-03 | Academy of Folklore & Latin Rhythms | [NAME] | Sinaloa | Pato Asado | Conf Room | 2025-02-14 15:51:00
681 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 38-15 | Houston Ballet Folklorico |  | [NAME] | El Gallito | Conf Room | 2025-02-14 20:52:00
439 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 17-02 | Ballet [NAME] | [NAME] | Jalisco | El Son de la Negra | Conf Room | 2025-02-15 14:40:00
723 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 42-01 | [NAME] | [NAME] | Puebla | Al Ritmo de mi Violin | Conf Room | 2025-02-15 19:24:00
193 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 09-02 | Ballet [NAME] | Sofia Magana | [NAME] | El Naranjo | Conf Room | 2025-02-16 11:16:00
195 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 09-04 | Ballet [NAME] | [NAME] | Yucatan | [NAME] | Conf Room | 2025-02-16 11:24:00
238 | 01-P/NP01-YC01-Solo02-Int. |  | Division 2 |  |  |  |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 01-P/NP01-YC01-Solo02-Int. | 10-05 | Ballet [NAME] | [NAME] | Jalisco | El Tranchete | Conf Room | 2025-02-16 13:24:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 01-P/NP01-YC01-Solo02-Int. Count