Extracting Dates and Amounts from Raw Export

[copyboy007]

Am trying to extract data from an exported paste of raw data in Column B (column A was only added for reference) of invoices (some include payments to subcontractors plus a subtotal), which merged and split some items (e.g., invoice numbers split into two rows; amounts were merged with text and dates). The formulas I've researched are in a grey shade when I was brainstorming how to group the invoice items and extract whatever I can. It also exported the page headers between page breaks, which is throwing off some formula results. The last two columns on the right that are not shaded, which contain sample data of what I'm trying to extract for each line. But, this still needs tweaks (or overhauling). Can this generic export become a proper data source to generate a pivot table that sees how every item is connected to every invoice.

Generic Sample2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Row	Exported Raw Data	a	b	c	d	abcd	All Invoices	Invoice w/ Sub	Invoice w/o Sub	All Dates	All Dates	Sub Amount	Sub	Inv. Total	Inv. Date
2	2	1 YZ9876543	2	0	0	2	2	YZ98765432A	YZ98765432A						75500.00	2/25/13
3	3	2A	0	3	0	0	3	YZ98765432A	YZ98765432A						75500.00	2/25/13
4	4	Company A, Inc.(CCE) $21,897.15	0	0	4	0	4	YZ98765432A	YZ98765432A				21897.15	Company A, Inc.(CCE)	75500.00	2/25/13
5	5	Better Company, Inc.(CCE) $2,186.70	0	0	5	0	5	YZ98765432A	YZ98765432A				2186.7	Better Company, Inc.(CCE)	75500.00	2/25/13
6	6	Worse(CCE) $26,107.58	0	0	6	0	6	YZ98765432A	YZ98765432A				26107.58	Worse(CCE)	75500.00	2/25/13
7	7	Laundry Svc. Inc.(EEE) $1,000.00	0	0	7	0	7	YZ98765432A	YZ98765432A				1000	Laundry Svc. Inc.(EEE)	75500.00	2/25/13
8	8	Clothing, Inc.(FFE) $8,790.00	0	0	8	0	8	YZ98765432A	YZ98765432A				8790	Clothing, Inc.(FFE)	75500.00	2/25/13
9	9	Total subconsultant Cost for Invoice 1: $59,981.43	0	0	9	0	9	YZ98765432A	YZ98765432A						75500.00	2/25/13
10	10	2/25/13 $75,500.00	0	0	0	10	10	YZ98765432A	YZ98765432A			Date			75500.00	2/25/13
11	11	2 AB2109876	0	0	0	0		AB21098768		AB21098768	xxx
12	12	8	0	0	0	0		AB21098768		AB21098768
13	13	2/25/13 $2,977.50	0	0	0	0		AB21098768		AB21098768		Date
14	14	Page 1 of 4	0	0	0	0		1 of 4Xyz Service Paperwork System		1 of 4Xyz Service Paperwork System	xxx
15	15	Xyz Service Paperwork System	0	0	0	0		1 of 4Xyz Service Paperwork System		1 of 4Xyz Service Paperwork System
16	16	DETAILED STUFF INVOICE REPORT	0	0	0	0		1 of 4Xyz Service Paperwork System		1 of 4Xyz Service Paperwork System
17	17	Printed: 4/30/2020	0	0	0	0		1 of 4Xyz Service Paperwork System		1 of 4Xyz Service Paperwork System		Date
18	18	(Contract Title)	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services	xxx
19	19	Amazing Humble Services	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
20	20	Prime Consultant: Amazing Humble Services Contract Number: A123456	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
21	21	Task:01 Thingamajig Special Materials	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
22	22	Inv	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
23	23	No.	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
24	24	Vendor	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
25	25	Inv No.	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
26	26	Invoice	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
27	27	subconsultant	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
28	28	Invoice	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
29	29	Date	0	0	0	0		Title)Amazing Humble Services		Title)Amazing Humble Services
30	30	10 102113	30	0	0	0	30	1021133	1021133
31	31	3	0	31	0	0	31	1021133	1021133
32	32	Company A, Inc.(CCE) $7,551.14	0	0	32	0	32	1021133	1021133				7551.14	Company A, Inc.(CCE)
33	33	Better Company, Inc.(CCE) $3,658.89	0	0	33	0	33	1021133	1021133				3658.89	Better Company, Inc.(CCE)
34	34	Worse(CCE) $713.40	0	0	34	0	34	1021133	1021133				713.4	Worse(CCE)
35	35	Z&A Industrial Stuff(OOE) $190.00	0	0	35	0	35	1021133	1021133				190	Z&A Industrial Stuff(OOE)
36	36	Laundry Svc. Inc.(EEE) $575.00	0	0	36	0	36	1021133	1021133				575	Laundry Svc. Inc.(EEE)
37	37	Clothing, Inc.(FFE) $1,465.00	0	0	37	0	37	1021133	1021133				1465	Clothing, Inc.(FFE)
38	38	Total subconsultant Cost for Invoice 10: $14,153.43	0	0	38	0	38	1021133	1021133
39	39	10/31/15 $19,520.25	0	0	0	39	39	1021133	1021133			Date
40	40	4 GH456789	40	0	0	0	40	GH4567894	GH4567894	GH4567894	xxx
41	41	4	0	41	0	0	41	GH4567894	GH4567894
42	42	Company A, Inc.(CCE) $7,377.12	0	0	42	0	42	GH4567894	GH4567894				7377.12	Company A, Inc.(CCE)
43	43	Better Company, Inc.(CCE) $3,722.72	0	0	43	0	43	GH4567894	GH4567894				3722.72	Better Company, Inc.(CCE)
44	44	Worse(CCE) $2,085.28	0	0	44	0	44	GH4567894	GH4567894				2085.28	Worse(CCE)
45	45	Z&A Industrial Stuff(OOE) $190.00	0	0	45	0	45	GH4567894	GH4567894				190	Z&A Industrial Stuff(OOE)
46	46	Laundry Svc. Inc.(EEE) $1,075.00	0	0	46	0	46	GH4567894	GH4567894				1075	Laundry Svc. Inc.(EEE)
47	47	Clothing, Inc.(FFE) $1,465.00	0	0	47	0	47	GH4567894	GH4567894				1465	Clothing, Inc.(FFE)
48	48	Total subconsultant Cost for Invoice 11: $15,915.12	0	0	48	0	48	GH4567894	GH4567894
49	49	10/30/16 $18,181.18	0	0	0	49	49	GH4567894	GH4567894			Date
Sheet1 (2)

Cell Formulas
Range	Formula
C2:C49	C2	=IF(AND(D2=0,D3<>0),A2,0)
D2:D49	D2	=IF(AND(E2=0,E3<>0),A2,0)
E2:E49	E2	=IF(OR(ISNUMBER(SEARCH({") $","total subconsultant cost"},B2))),A2,0)
F2:F49	F2	=IF(AND(E2=0,E1<>0),A2,0)
G2:G49	G2	=IFERROR(LOOKUP(2,1/(C2:F2>0),C2:F2),"")
H2:H49	H2	=IF(OR(K2="xxx",C2<>0),MID($B2,FIND(" ",$B2)+1,99)&$B3,H1)
I2:I49	I2	=IF(C2<>0,MID($B2,FIND(" ",$B2)+1,99)&$B3,IF(G2="","",I1))
J2:J49	J2	=IF(K2="xxx",MID($B2,FIND(" ",$B2)+1,99)&$B3,IF(G2="",J1,""))
K2:K49	K2	=IF(COUNTIF(B1,"*/*/*"),"xxx","")
L2:L49	L2	=IF(LEN(B2)-LEN(SUBSTITUTE(B2,"/",""))>1,"Date","")
M2:M49	M2	=IF(ISNUMBER(SEARCH(") $",B2)),MID($B2,FIND(" $",$B2)+1,99)+0,"")
N2:N49	N2	=IF(ISNUMBER(SEARCH(") $",B2)),LEFT(B2,(FIND(") $",B2)-0)),"")

 

[copyboy007]

So, any ideas about formulas for columns O and P to get those manually entered results?