Number.Mod Example.xlsx

	A	B	D	E	F
1	Source Data to Upload to Power Query:		End Query:
2
3	Invoice Number	Sales Amount	Invoice Number	Sales Amount	Audit
4	PP001	456.32	PP003	1240	Audit
5	PP002	7842	PP006	3200	Audit
6	PP003	1240	PP008	1700	Audit
7	PP004	784.56	PP009	120.45	Audit
8	PP005	1244	PP010	99.99	Audit
9	PP006	3200	PP011	100	Audit
10	PP007	1704	PP016	99.99	Audit
11	PP008	1700
12	PP009	120.45
13	PP010	99.99
14	PP011	100
15	PP012	1489
16	PP013	7001
17	PP014	12506
18	PP015	12506.56
19	PP016	99.99
20	PP017	5467
21	PP018	121.45
22	PP019	122.6
23	PP020	122.32
24	PP021	122.45
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100