tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__128__DYNEGY-ICE VOL Jun7
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE: |  |  |  |  |  |  | Data
 |  |  | Data |  |  | Trader | Product | Qty Units | Transactions | Volume
Trader | Product | Qty Units | Transactions | Volume |  | Carson, M | Firm-LD Peak | MWhs | 4 | 12800
[NAME], G | NG Fin BS, LD1 for IF | MMBtus | 1 | 755000 |  |  | Firm-LD Peak Total |  | 4 | 12800
 | NG Fin BS, LD1 for GDM | MMBtus | 2 | 2265000 |  | Dorland, C | Firm-LD Peak | MWhs | 23 | 107200
Goodell, S | NG [NAME], FP | MMBtus | 1 | 5000 |  |  | Firm-LD Peak Total |  | 23 | 107200
[NAME], E | NG Fin BS, LD1 for IF | MMBtus | 1 | 1510000 |  | Richter, J | Firm-LD Off-Peak | MWhs | 1 | 8600
Grand Total |  |  | 5 | 4535000 |  |  | Firm-LD Off-Peak Total |  | 1 | 8600
 |  |  |  |  |  | Stalford, R | Firm-LD Peak | MWhs | 3 | 2400
 |  |  |  |  |  |  | Firm-LD Peak Total |  | 3 | 2400
 |  |  |  |  |  | Motley, M | Firm-LD Peak | MWhs | 1 | 10800
 |  |  |  |  |  |  | Firm-LD Peak Total |  | 1 | 10800
 |  |  |  |  |  | Fischer, M | Firm-LD Peak | MWhs | 2 | 7600
 |  |  |  |  |  |  | Firm-LD Peak Total |  | 2 | 7600
 |  |  |  |  |  | Grand Total |  |  | 34 | 149400
Spreadsheet: 717501d1612704166-extract-values-using-left-right-or-mid-function-left_right_function_extract_sample_3
Sheet: Here

Name | Name_1 | Name_2
 | Abdelnour - Hex | Habig
 | [NAME] | Habig
 | Abdelnour | Habig
 | Abdelrahman | [NAME]
 | [NAME] | Hable
 | Macchi | Hable M.
 | Sablan | [NAME]
 | Deer Ann | Chiocemax
 | Deer | Chiocemax Jr
 | Deer | Chiocemax-Ben
 | [NAME] | Chiocemax
 | Hachey M | Yan
 | [NAME] | [NAME]
 | Head | [NAME]
 | Head | Chroster
 | Luther-Ara | English
 | Luther | English
 | Macchio Jon | Hach
 | Macchio | Hach
 | Macchio | [NAME]
 | [NAME] | Backen
 | Otoma | Look
 | Stormy | English
 | Bock | [NAME]
 | Abdelnour | Habig M
 | [NAME] | Good
 | Kinda | Good Mae Claire
 | Abdelnour | Habig
Spreadsheet: 751111d1633887551-finding-numbers-in-text-string-finding-numbers-in-text-string
Sheet: Sheet1

This line has been disconnected due to terminations after the customer accepted a new offer , STS 1662508 + other tekst
This line has been disconnected due to terminations after the customer accepted a new offer , STS 1661987
This line has been disconnected due to terminations after the customer accepted a new offer , STS  1660174
This line has been disconnected due to terminations after the customer accepted a new offer , STS 1662621
This line has been disconnected due to terminations after the customer accepted a new offer , STS 1663104
This line has been disconnected due to terminations after the customer accepted a new offer 1661986
This line has been disconnected due to terminations after the customer accepted a new offer 1661986
This line has been disconnected due to terminations after the customer accepted a new offer 1662022
This line has been disconnected due to issues with bill. The complaint’s number is 1808975  Contact ID: 528874
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528873
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528840
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528847
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528850
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528848
dfsdfsdfsdfdsf 123 ddfdsfsdfds
Spreadsheet: 179130d1347034835-two-dimensional-vlook-up-find-team-reporting-to-shift-sample_workbook_w_reporting_team
Sheet: Shift Roaster

Reporting Team | Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5
2012-09-01 00:00:00 | OFF | OFF | Team 2 | Team 2 | Team 3 | Team 3 | Team 4 | Team 4 | Team 5 | Team 5
2012-09-02 00:00:00 | Team 1 | Team 1 | Team 2 | Team 2 | Team 3 | Team 3 | Team 4 | Team 4 | OFF | OFF
2012-09-03 00:00:00 | Team 1 | Team 1 | Team 2 | Team 2 | OFF | OFF | Team 4 | Team 4 | OFF | OFF
2012-09-04 00:00:00 | Team 1 | Team 1 | Team 2 | Team 2 | OFF | OFF | OFF | OFF | Team 5 | Team 5
2012-09-05 00:00:00 | Team 1 | Team 1 | Team 2 | Team 2 | Team 3 | Team 3 | OFF | OFF | Team 5 | Team 5
2012-09-06 00:00:00 | Team 1 | Team 1 | OFF | OFF | Team 3 | Team 3 | Team 4 | Team 4 | Team 5 | Team 5
Timing | Shift
06:00 - 14:00 | A
14:01 - 22:00 | B
22:01 - 05:59 | C
Start Shift | End Shift
 |  | C
 |  | A
 |  | B
 |  | C
Spreadsheet: 811999d1672910629-prospect-calculation-in-months-excel-issue
Sheet: Blad1

[NAME] | Status | Succes factor | January | February | March | April | May | June | July | August | September | October | November | December
Project X | Prospect | 0.25
Project Y | Client | 1
Project Z | Prospect | 0.75
Spreadsheet: 134758d1325616718-retaining-formatting-when-using-the-text-function-txt_num_percent
Sheet: sheet1

For the years of 2005-2010 overall a 5.27%
For the years of 1995-2010 overall a | reduction was achieved for a total of | for the project
NOVEMBER | DECEMBER |  | $ [NAME] | % Difference
-36389.04 | -35347.44 |  | 1041.599999999999 | 0.02862400327131462
-69328.02 | -68218.4 |  | 1109.62000000001 | 0.01600536118008289
-89263.4 | -78108.52 |  | 11154.87999999999 | 0.1249658874745976
-121394.63 | -120078.8 |  | 1315.830000000002 | 0.01083927682797832
-193609.53 | -188753.22 |  | 4856.309999999998 | 0.02508301115136222
-396173.83 | -367920.92 |  | 28252.91000000003 | 0.07131442781064068
November Total | December Total |  | $ [NAME] | % Difference
-906158.45 | -858427.3 |  | 47731.14999999991 | 0.052674176354036
Spreadsheet: 32874d1229036821-drop-down-list-help-subcontractor
Sheet: Sheet1

 |  |  | Cell A17 has SUBTOTAL formula that triggers a Worksheet_Calculate
 |  |  | event every time the AutoFilter is used. That activated the macro
 |  |  | to do a straight cut and paste.
Subcontractor | None | None | There is a bogus ZZ option at the bottom, and if the macro ever sees
1 |  |  | that value as the value to paste, it stops and prints "None" instead
Plumber 01
Plumber 02
[NAME] 03
Plumber 04
Plumber 05
[NAME] 06
Plumber 07
Plumber 08
Plumber 09
[NAME] 10
[NAME] 11
[NAME] 12
Plumber 13
Plumber 14
Plumber 15
Plumber 16
Plumber 17
Plumber 18
Plumber 19
Plumber 20
Plumber 21
Plumber 22
Plumber 23
ZZ
Spreadsheet: 694163d1599401288-excel-to-match-pay-slip-figures-with-payroll-figures-according-to-period-2020-09-05-oeldere-sunboy-694162d1599400282-excel-to-match-pay-slip-figures-with-payroll-figu
Sheet: PAYSLIP

 | I am kindly asking for a formula which can match basic salary , Over time and Transport and House allowance with Period (C7) and code number (C9). Please not that on C7 and C9 |  |  |  |  |  |  |  |  |  |  | 1 | CA1
 | there is drop down list to select periods and employee code numbers. And also formula for cumulative basic salary ( C24).
 | DESIRED OUTCOME |  |  |  |  |  |  |  |  |  |  | 2 | CA2
 |  |  | TNS P/L |  |  |  |  |  |  |  |  | 4 | CA3
 |  |  |  |  |  |  |  |  |  |  |  | 5
 | 2020-09-06 00:00:00
 | Period | 2 |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 | Code | CA3 |  |  |  | Desgnation |  |  |  |  |  | 8
 | Name |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 10
 | Eearnings | Over time Hours | Rate | Amount |  | Deductions | Amount |  |  |  |  | 11
 |  |  |  |  |  | Pension |  |  |  |  |  | 12
 |  |  |  |  |  | Nssa
 |  |  |  |  |  | Nec
 |  |  |  |  |  | Medical Aid
 |  |  |  |  |  | PAYE
 |  |  |  |  |  | Aids Levy
 |  |  |  |  |  | Net Salary
 |  | #N/A
 | Cummulative
 | Basic Salary
Spreadsheet: 758878d1639138877-split-cell-value-based-on-number-after-every-number-appereance-in-cell-example
Sheet: Sheet1

text | formula to extract text based on number position  in array (as a word) | formula to extract number position in array (as a word) | formula to extract text based on last number |  | desired output
1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci |  |  |  |  | 1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci
1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat |  |  |  |  | 1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci | 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat
1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat 1617 [NAME] din emisiuni de obligaţiuni |  |  |  |  | 1614 Împrumuturi externe din emisiuni de obligaţiuni garantate de stat | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci | 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat | 1617 [NAME] din emisiuni de obligaţiuni
 |  |  |  |  |  | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci
 |  |  |  |  |  | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci | 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat
 |  |  |  |  |  | 1615 Împrumuturi externe din emisiuni de obligaţiuni garantate de bănci | 1616 Împrumuturi interne din emisiuni de obligaţiuni garantate de stat | 1617 [NAME] din emisiuni de obligaţiuni
 | 1615 | 11
 | 1616 | 21
Spreadsheet: 776749d1649882027-adding-starting-ticket-number-to-raffle-ticket-tracking-raffle_drawing
Sheet: Sheet2

Ticket Number | Name
Spreadsheet: 771201d1646502676-unique-count-of-of-column-a-where-column-b-contains-word-test
Sheet: Dashboard

Active Users Sheet | Manual Count | Formula Total |  | Values
Unique count of IDs where Match = Yes | 593 |  |  | UniqueID | 593
Unique count of IDs where Match = Yes and Team = Green | 26 |  |  | Green | 26
Unique count of IDs where Match = Yes and Team contains "Green" | 86 |  |  | ContainGreen | 86
Unique count of IDs where Match = Yes and Team contains "Blue" and Dept contains "Pears" | 20 |  |  | Blue_Pears | 20
Logins Sheet | Manual Count | Formula Total |  | Values
Unique count of IDs where status = active and login is in last 6 months | 300 |  |  | Active_6M | 300
Unique count of IDs where status = active and Match = Yes and login is in last 6 months | 66 |  |  | Active_6M_Yes | 66
Spreadsheet: 658013d1579122262-index-and-match-fill-table-with-unique-values-index-match-issue-example
Sheet: Accounts Module

 | Accounts Module
 | Contract ID | First Name | Last Name | Start Date | End Date | Day Rate |  | <<< This is what I would like it to look like
 | 2 | [NAME] | Dough | 2019-01-01 00:00:00 | 2019-03-31 00:00:00 | 550
 | 6 | [NAME] | Dough | 2019-07-01 00:00:00 | 2019-09-30 00:00:00 | 550
 | 7 | [NAME] | Smith | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 400
Spreadsheet: 855563d1705091820-find-name-and-indicate-line-and-fraction-1a
Sheet: MOV DDA

 |  |  |  |  |  |  | Link Balanço
 |  |  |  |  |  |  |  |  | NOME | NOME | LINHA | FR.
 | MOVIMENTO DA CONTA DE DEPÓSITOS À ORDEM |  |  |  |  |  |  |  | [NAME]
 | Data | Ref | Descrição
 | 2023-12-31 00:00:00 | ----- | [NAME] à Ordem
 | 2024-01-02 00:00:00 |  | 29/12 TRF CRED SEPA+ 00428502 DE RITA PAIVA RAPOSO
 | 2024-01-02 00:00:00 |  | TRF CR SEPA+ 0002606 DE ANA LUISA SOARES CARNEIRO
 | 2024-01-02 00:00:00 | 1 | [NAME]
 | 2024-01-02 00:00:00 | 2 | Produtos Limpeza |  |  |  |  |  |  |  | 94
 | 2024-01-02 00:00:00 |  | Reforço Caixa |  |  |  |  |  |  |  | 28
 | 2024-01-03 00:00:00 |  | TRF CR SEPA+ 0002609 DE SANDRA MIRANDA GOMES
 | 2024-01-03 00:00:00 |  | TRF CR SEPA+ 0002610 DE MARIA HELENA CASTRO MATA
 | 2024-01-03 00:00:00 |  | 02/01 TRF CRED SEPA+ 00075095 DE M GUADALUPE INACIA
 | 2024-01-04 00:00:00 |  | TRF CR SEPA+ 0002611 DE Jens [NAME]
 | 2024-01-04 00:00:00 |  | TRF CR INTRAB 72 DE ROSA MARIA FIDALGO DOS S F M CERVEIRA
 | 2024-01-05 00:00:00 |  | TRF CR SEPA+ DE CONCEICAO MARIA SANTOS CARVALHO CRUZ
 | 2024-01-08 00:00:00 | 3 | Manutenção [NAME]. [NAME]
 | 2024-01-08 00:00:00 |  | TRF CR SEPA+ 0002613 DE NUNO [NAME]
 | 2024-01-08 00:00:00 |  | TRF CR SEPA+ 0002613 DE NUNO [NAME]
 | 2024-01-08 00:00:00 |  | 06/01 TRF CRED SEPA+ 00078225 DE M LAURA COUTINHO
 | 2024-01-09 00:00:00 | 4 | Desentupimento Caixa
 | 2024-01-10 00:00:00 |  | TRF CR SEPA+ 0002616 DE VIVIAN MARY CHAMBERS BULL
 | 2024-01-10 00:00:00 |  | TRF CR SEPA+ 0002617 DE SORAYA MITTICA SILVA
 | 2024-01-10 00:00:00 |  | 09/01 TRF CRED SEPA+ 00200264 DE LUIS FERNANDO BARROS
 | 2024-01-10 00:00:00 |  | 09/01 TRF CRED SEPA+ 00458972 DE NICOLE HOMEM MELLO
 | 2024-01-10 00:00:00 | 5 | COBRANCA TSU NIF=900577207 - 202312
 | 2024-01-10 00:00:00 |  | Reforço Caixa
Spreadsheet: 749906d1633091195-how-to-return-a-range-of-dates-between-two-cell-values-workday-only-datereturn
Sheet: Sheet1

 | Beg Date |  |  |  | End Date
 | 2021-09-01 00:00:00 |  |  |  | 2021-11-30 00:00:00 |  |  |  | Dates to exclude
 |  |  |  |  |  |  |  |  | 2021-09-13 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00
Spreadsheet: 328056d1403778492-draw-mlm-binary-tree-left-and-right-child-binary-tree
Sheet: Data

Sponser ID | Sponsor Name | Postion | ID | Member [NAME]
150 | [NAME] | Left | 200 | [NAME]
150 | [NAME] | Right | 201 | Karan
200 | Shankar | Left | 202 | Darshan
200 | Shankar | Right | 204 | [NAME]
201 | Karan | Left | 205 | [NAME]
201 | Karan | Right | 206 | Beena
207 | Sandeep | Right | 207 | Sandeep
 |  |  |  | This data input here
Spreadsheet: 778867d1651408116-comparing-two-column-values-with-condition-test_data
Sheet: Sheet1

ColA | ColB | ColC |  | ColE | ColF
16 | 4 | 1.0
30 | 16 | 0.0
42 | 16 | 5.0 |  | 16 | 5.0
48 | 30 | 4.0 |  | 30 | 4.0
50 | 49 | 6.0
56 | 50 | 1.0 |  | 50 | 1.0
94 | 94 | 0.0
103 | 94 | 9.0 |  | 94 | 9.0
116 | 103 | 0.0
126 | 103 | 6.0 |  | 103 | 6.0
140 | 126 | 4.0 |  | 126 | 4.0
144 | 140 | 7.0 |  | 140 | 7.0
219 | 142 | 8.0
237 | 219 | 3.0 |  | 219 | 3.0
243 | 237 | 3.0 |  | 237 | 3.0
245 | 243 | 1.0 |  | 243 | 1.0
264 | 245 | 4.0 |  | 245 | 4.0
280 | 264 | 6.0 |  | 264 | 6.0
283 | 280 | 7.0 |  | 280 | 7.0
287 | 283 | 9.0 |  | 283 | 9.0
292 | 287 | 1.0 |  | 287 | 1.0
308 | 296 | 1.0
309 | 308 | 4.0 |  | 308 | 4.0
312 | 309 | 6.0 |  | 309 | 6.0
321 | 317 | 7.0
326 | 321 | 1.0 |  | 321 | 1.0
335 | 326 | 5.0 |  | 326 | 5.0
336 | 336 | 0.0
356 | 336 | 6.0 |  | 336 | 6.0
Spreadsheet: theresa_staab__39629__Enron Lost Creek Statement Email 0801
Sheet: Enron (Devon) Settlement

 |  |  | Service Invoice |  | [NAME] To: | Remit To:
 |  | Invoice #: | LC-F-005  37104 |  |  |  | Verification Date:
 |  |  |  |  | Enron North America | ABA Routing Number:  026 002 574 | 2001-09-14 00:00:00
 |  |  |  |  | 1200 17th Street, [NAME] 2750 | Bank Name:  Barclays Bank PLC
 |  |  |  |  | Denver, CO  80202 | City, State:  New York, NY | Due Date:
 |  |  |  |  |  | Account Number:  050 795 392 | 2001-09-28 00:00:00
 |  |  |  |  | Contact:  [NAME] | Contact:  [NAME] | Payment Method:
 |  |  |  |  | Tel:  (303) 575-6485 | Tel:  (713) 624-9133 | [NAME]
 |  |  |  |  | Fax: (303) 534-0552 | Fax: (713) 624 - 9616 | Terms:
 |  |  |  |  |  |  | Last day of Month received
Delivery Period: | Contract # | Meter # / Meter Name
2001-08-01 00:00:00 | LC-F-005
BTU factor | 1.08962
Monthly Activity |  | Nominated
 | Receipt | Delivered | Actual | Net Receipt | Receipt Net of Fuel
 | MMBtu | MMBtu | Fuel (0%) | MMBtu | Mcf
2001-08-01 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-02 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-03 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-04 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-05 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-06 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-07 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-08 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-09 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-10 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-11 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-12 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-13 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-14 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-15 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-16 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-17 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-18 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-19 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-20 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-21 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-22 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-23 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-24 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-25 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-26 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-27 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-28 00:00:00 | 0 | 0 | 0 | 0 | 0
2001-08-29 00:00:00 | 120.07832 | 14333 | 0 | 120.07832 | 110.2020153815092
2001-08-30 00:00:00 | 10715.66176 | 14348 | 0 | 10715.66176 | 9834.310823956976
2001-08-31 00:00:00 | 12589.09608 | 0 | 0 | 12589.09608 | 11553.65731172335
Total | 23424.83616 | 28681 | 0 | 23424.83616 | 21498.17015106184
 |  | Volume (Mmbtu) | $/Mmbtu | Amount Due
 | Interruptible Fee | 23424.83616 | 0.48 | 11243.9213568
 | Total Volume: | 23424.83616 |  | Total Due | 11243.9213568
Spreadsheet: 267866d1380255240-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: TEXAS-42

 | COUNTY | CODE
 | [NAME] | 1
 | [NAME]
 | Angelina
 | Aransas
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Bailey
 | Bandera
 | Bastrop
 | Baylor
 | Bee
 | Bell
 | [NAME]
 | Blanco
 | Borden
 | Bosque
 | [NAME]
 | Brazoria
 | [NAME]
 | Brewster
 | Briscoe
 | Brooks
 | [NAME]
 | [NAME]
 | Burnet
 | Caldwell
 | [NAME]
 | Callahan
 | Cameron
 | Camp
 | [NAME]
 | [NAME]
 | [NAME]
 | Chambers
 | Cherokee
 | Childress
 | Clay
 | Cochran
 | Coke
 | [NAME]
 | Collin
 | Collingsworth
 | Colorado
 | Comal
 | Comanche
 | Concho
 | Cooke
 | Coryell
 | Cottle
 | Crane
 | Crockett
 | Crosby
 | Culberson
 | [NAME]
 | Dallas
 | Dawson
 | [NAME]
 | Delta
 | [NAME]
 | DeWitt
 | [NAME]
 | Dimmit
 | Donley
 | Duval
 | Eastland
 | Ector
 | Edwards
 | Ellis
 | El Paso
 | Erath
 | Falls
 | Fannin
 | Fayette
 | Fisher
 | [NAME]
 | Foard
 | Fort Bend
 | Franklin
 | Freestone
 | Frio
 | Gaines
 | Galveston
 | [NAME]
 | Gillespie
 | Glasscock
 | Goliad
 | Gonzales
 | Gray
 | [NAME]
 | [NAME]
 | Grimes
 | Guadalupe
 | Hale
 | Hall
 | [NAME]
 | Hansford
 | [NAME]
 | Hardin
 | [NAME]
 | [NAME]
 | Hartley
 | Haskell
 | Hays
 | Hemphill
 | Henderson
 | Hidalgo
 | Hill
 | Hockley
 | Hood
 | Hopkins
 | Houston
 | [NAME]
 | [NAME]
 | [NAME]
 | Hutchinson
 | Irion
 | [NAME]
 | [NAME]
 | Jasper
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Jones
 | Karnes
 | Kaufman
 | Kendall
 | [NAME]
 | Kent
 | Kerr
 | Kimble
 | King
 | Kinney
 | [NAME]
 | Knox
 | Lamar
 | Lamb
 | Lampasas
 | [NAME]
 | Lavaca
 | [NAME]
 | [NAME]
 | Liberty
 | Limestone
 | Lipscomb
 | Live Oak
 | Llano
 | Loving
 | Lubbock
 | [NAME]
 | McCulloch
 | [NAME]
 | McMullen
 | [NAME]
 | Marion
 | Martin
 | Mason
 | Matagorda
 | Maverick
 | Medina
 | Menard
 | Midland
 | Milam
 | Mills
 | Mitchell
 | Montague
 | Montgomery
 | Moore
 | Morris
 | Motley
 | Nacogdoches
 | Navarro
 | Newton
 | Nolan
 | Nueces
 | [NAME]
 | Oldham
 | Orange
 | Palo Pinto
 | Panola
 | Parker
 | [NAME]
 | Pecos
 | Polk
 | Potter
 | Presidio
 | Rains
 | Randall
 | [NAME]
 | Real
 | Red River
 | Reeves
 | Refugio
 | [NAME]
 | [NAME]
 | Rockwall
 | Runnels
 | Rusk
 | Sabine
 | [NAME]
 | San Jacinto
 | San Patricio
 | San Saba
 | Schleicher
 | Scurry
 | Shackelford
 | Shelby
 | [NAME]
 | Smith
 | [NAME]
 | [NAME]
 | [NAME]
 | Sterling
 | Stonewall
 | Sutton
 | Swisher
 | Tarrant
 | [NAME]
 | Terrell
 | [NAME]
 | Throckmorton
 | Titus
 | [NAME]
 | Travis
 | Trinity
 | Tyler
 | Upshur
 | Upton
 | Uvalde
 | [NAME]
 | [NAME]
 | Victoria
 | Walker
 | Waller
 | Ward
 | Washington
 | Webb
 | [NAME]
 | Wheeler
 | Wichita
 | [NAME]
 | Willacy
 | [NAME]
 | Wilson
 | Winkler
 | Wise
 | Wood
 | Yoakum
 | Young
 | [NAME]
 | Zavala
Spreadsheet: 61479d1262360275-macro-to-sort-data-sample
Sheet: Sorted Data

 |  |  |  |  |  | Country List
URN | Document Type | Company Code | Status | Scan
 |  |  |  |  |  | MS France
 |  |  |  |  |  | Denmark
 |  |  |  |  |  | Kenya
 |  |  |  |  |  | GmbH
 |  |  |  |  |  | Austria
 |  |  |  |  |  | Ivory Coast
 |  |  |  |  |  | MS senegal LLC
 |  |  |  |  |  | Luxembourg
 |  |  |  |  |  | MS Nigeria Limited
 |  |  |  |  |  | Morroco
 |  |  |  |  |  | Portugal
 |  |  |  |  |  | Spain
 |  |  |  |  |  | Rus LLC
 |  |  |  |  |  | Spanish Holding Company
 |  |  |  |  |  | MDCC
 |  |  |  |  |  | Italy
 |  |  |  |  |  | Switzerland
Spreadsheet: 857165d1706205673-textjoin-with-delimited-for-same-name-textjoin-by-same-name
Sheet: Sheet1

Company Name | Amended Name |  |  | Amended Name | Result
ABC Ltd (Taiwan) | ABC Ltd (Taiwan) |  |  | ABC Ltd (Taiwan)
ABC Ltd (Taiwan) ([NAME]) | ABC Ltd (Taiwan) |  |  | Tiger Co
ABC Ltd (Taiwan) (XJH22222) | ABC Ltd (Taiwan) |  |  | Black Pte Ltd
Tiger Co (JZZ88888) | Tiger Co |  |  | Monbly (Pte) Ltd
Tiger Co (ABC77777) | Tiger Co
Tiger Co | Tiger Co |  |  |  | ABC Ltd (Taiwan), ABC Ltd (Taiwan) ([NAME]), ABC Ltd (Taiwan) (XJH22222)
Black Pte Ltd | Black Pte Ltd |  |  | Tiger Co | Tiger Co (JZZ88888), [NAME] (ABC77777), [NAME]
Black Pte Ltd (PKD76251) | Black Pte Ltd |  |  | Black Pte Ltd | Black Pte Ltd, Black Pte Ltd (PKD76251)
Monbly (Pte) Ltd | Monbly (Pte) Ltd |  |  | Monbly (Pte) Ltd | Monbly (Pte) Ltd, Monbly (Pte) Ltd (HTT21212)
Monbly (Pte) Ltd (HTT21212) | Monbly (Pte) Ltd
Spreadsheet: 759403d1639513002-dynamic-array-challenge-filter-from-multiple-tables-test-to-figure-out-groupings
Sheet: Sheet1

Name | AlternateRoute | PrimaryRoute |  | Building | Route | Clearance | PropMgr |  |  | Name | Clearance | Status
[NAME] | B | A |  | Bldg1 | A | Gold | [NAME] |  |  | [NAME] | Gold | Level1
[NAME] | D | A |  | Bldg2 | A | Silver | [NAME] |  |  | [NAME] | Silver | Level1
[NAME] | A | B |  | Bldg3 | B | Gold | Smith |  |  | [NAME] | Gold | Level2
[NAME] | A | B |  | Bldg4 | C | Silver | [NAME] |  |  | [NAME] | Silver | Level2
[NAME] | B | C |  | Bldg5 | C | [NAME] | Smith |  |  | [NAME] | [NAME] | Level1
Carol | C | D |  | Bldg6 | D | Gold | [NAME] |  |  | Carol | Silver | Level3
The three tables above all have many more rows and will grow over time…
Filter by ALL or by PropMgr
 | Smith
Result - Shows all Names & statuses who have as primary or alternate routes - Either in a pivot table or a dynamic list
 | PropMgr | Building | Route | Clearance | AlternateRoute | PrimaryRoute | Name | Status
 | [NAME] | Bldg1 | A | Gold | B | A | [NAME] | Level2
 | [NAME] | Bldg2 | A | Gold | B | A | [NAME] | Level2
 | [NAME] | Bldg1 | A | Silver | D | A | [NAME] | Level2
 | [NAME] | Bldg2 | A | Silver | D | A | [NAME] | Level2
 | [NAME] | Bldg4 | C | [NAME] | B | C | [NAME] | Level1
 | [NAME] | Bldg6 | D | Silver | C | D | Carol | Level3
 | Smith | Bldg3 | B | Gold | A | B | [NAME] | Level1
 | Smith | Bldg3 | B | Silver | A | B | [NAME] | Level1
 | Smith | Bldg3 | B |  | A | B | [NAME]
 | Smith | Bldg5 | C | [NAME] | B | C | [NAME] | Level1