ABCDEF
1
DateDescriptionAmountRunning Bal.ВЫВЕДЕМ ТО, ЧТО ПОСЛЕ COMPANY: и до первого пробела (или до конца строки)ВЫВЕДЕМ СУММУ ИЗ "С:C", ЕСЛИ В "B:B" СЛОВО WIRE
2
=ARRAYFORMULA(ifna( REGEXEXTRACT(B3:B18;"COMPANY:([^ ]+)")))=ARRAYFORMULA( if(REGEXMATCH(B3:B19;"(?i)wire");C3:C19;))
3
10/01/2021Beginning balance as of 10/01/2021310420,82
4
10/01/2021Online Banking transfer to CHK Confirmation# 5308506223-$1 050,00309370,82
5
10/01/2021Online Banking transfer to CHK Confirmation# 7208510957-$174,13309196,69
6
10/01/2021Online Banking transfer to CHK Confirmation# 5308513228-$35,00309161,69
7
10/01/2021. CO ID:1492934832948 CCD PMT INFO:SETTLE 9/29/21 COMPANY:GKL-$21 726,41287435,28GKL
8
10/04/2021Online Banking transfer from CHK 7019 Confirmation# 5217215917$2 895,00290330,28
9
10/04/2021CO ID:1471426777 CCD PMT INFO:SETTLE COMPANY:FGK 9/30/21-$27 774,36262555,92FGK
10
10/05/2021WIRE TYPE:WIRE IN DATE: 211005 TIME:1134 ET TRN:2021100500322503 SEQ:2021100500078578/342376 ORIG:ADCOMBO LP ID:4122526254 SND BK:WELLS FARGO B ANK NA ID:0407 PMT DET:100191024750751 PAYOUTS TO AFFILIATES$69 985,00332540,92$69 985,00
11
10/05/2021WIRE TYPE:WIRE IN DATE: 211005 TIME:1134 ET TRN:2021100500322504 SEQ:2021100500078579/342384 ORIG:ADCOMBO LP ID:4122526254 SND BK:WELLS FARGO B ANK NA ID:0407 PMT DET:100191024750764 PAYOUTS TO AFFILIATES$29 985,00362525,92$29 985,00
12
10/05/2021WIRE TYPE:WIRE IN DATE: 211005 TIME:0537 ET TRN:2021100500123504 SEQ:S06127806BFC01/092929 ORIG:ADCOMBO LP ID:DK20890000905864 SND BK:CITIBAN K, N.A. ID:0008 PMT DET:DIGITAL MARKETING SERVICES ,INV GGT.04/10/2021., DD 04.10.2021$3 475,00366000,92$3 475,00
13
10/05/2021Online Banking transfer from CHK Confirmation# 14432$1 930,00367930,92
14
10/05/2021WIRE TYPE:INTL OUT DATE:211005 TIME:1348 ET TRN:2021100500377583 SERVICE REF:381194 BNF COMPANY:ABC LP ID BNF BK:BANKING PMT DET:358082126 REFUND DEPOSIT FOR MARKETING SERVI POP SERVICES-$4 115,00363815,92ABC-$4 115,00
15
10/05/2021PAY DES:. COMPANY:DFV 7 CCD PMT INFO:SETTLE 10/01/21-10/03/21-$63 271,15300544,77DFV
16
10/05/2021Prfd Rwds for Bus-Wire Fee Waiver of $15$0,00300544,770
17
10/05/2021Prfd Rwds for Bus-Wire Fee Waiver of $15$0,00300544,770
18
10/05/2021Prfd Rwds for Bus-Wire Fee Waiver of $15$0,00300544,770
19
20
21