Compare Data for Two Dates - Dynamically (without VBA)

[bharat7002416]

Hi there,
I am work with logistics and I look after dispatches for clients. I have a list of operations (undergoing, completed and initiated) for a given date. I have complied the report for various dates in a single excel sheet and I keep adding data to that sheet every morning. I am looking for a solution that pics the last 2 days from "Report Date" column and filter them out as mentioned in column G, H and I. Say, a client code was there in the list of 08-Apr-21 (report date) and his delivery had completed the same day, then the concerned client code be marked as "delivered" in column H and if a client code was added to the list of 09-Apr-21 then column I should list is out as "underway". Please bear in mind that a new list is circulated every morning and it is added to my compilation, hence my list is dynamic and keeps updated every morning. The client code may repeat, however the client account number changes with every row. I am not looking for VBA as my organization does not permit macros from backend, and it would be great if this solution is developed in Excel 2007 as many of the systems in my office does not have Office 365. Please help me out, as this helps me to save at least 2 hours of my office hours. An indicative data (with 250 rows) is attached with this post - to give you a better idea of the data, despite the norms to keep sample data to very few rows.

Sample Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Account No.	ClientCode	Value	Map Code	Report Date				Client Code	Removed	Added
2	59212	VADIA	0	104	31-03-21
3	73600	IRANI	0	120	31-03-21
4	76471	IRANI	0	125	31-03-21
5	73655	IRANI	0	125	31-03-21
6	76186	IRANI	0	120	31-03-21
7	31746	UBHAI	103202	125	31-03-21
8	76933	LANKI	294446.63	126	31-03-21
9	76012	LANKI	1279590	120	31-03-21
10	61837	RDIYA	62074.85	125	31-03-21
11	61565	RDIYA	1904218	120	31-03-21
12	8997	ARIYA	2698576	120	31-03-21
13	95153	MECHA	50980.34	120	31-03-21
14	50662	ATHOD	188730	120	31-03-21
15	45386	RAVAT	0	104	31-03-21
16	95596	BIND	2134483	120	31-03-21
17	32981	BIND	57611	125	31-03-21
18	10916	BIND	424941	126	31-03-21
19	42906	ATHOD	6007779	120	31-03-21
20	20108	ATHOD	3442682.94	126	31-03-21
21	81322	HNABH	1205726.97	120	31-03-21
22	86175	HNABH	22454.85	125	31-03-21
23	94882	abhai	2180116	120	31-03-21
24	12292	abhai	764329.08	126	31-03-21
25	14038	SVAMI	1412560	128	31-03-21
26	54720	SVAMI	46196.14	125	31-03-21
27	8403	VORA	52802.1	125	31-03-21
28	92912	VORA	1912952.63	126	31-03-21
29	72436	VORA	4053205	120	31-03-21
30	24036	NERIA	296554.66	120	31-03-21
31	93392	RBHAI	732567.15	120	31-03-21
32	38463	HBHAI	597066	120	31-03-21
33	44170	HBHAI	9816	125	31-03-21
34	75011	HDIYA	1795491	128	31-03-21
35	93539	HDIYA	55098	125	31-03-21
36	49007	UBHAI	469638.61	126	31-03-21
37	41348	UBHAI	1315783	120	31-03-21
38	61317	ELIYA	196349	104	31-03-21
39	14621	nbhai	245601	125	31-03-21
40	86239	nbhai	3265005	120	31-03-21
41	6369	nbhai	2241935.61	126	31-03-21
42	79535	RAOL	3169751	120	31-03-21
43	35063	HBHAI	873635	102	31-03-21
44	3244	IMOD	65365.56	120	31-03-21
45	15036	RBHAI	505292.06	126	31-03-21
46	2923	RBHAI	781374	120	31-03-21
47	34818	khani	19076.52	125	31-03-21
48	45858	khani	199080	126	31-03-21
49	26969	khani	941877	120	31-03-21
50	26623	GHELA	1362217	120	31-03-21
51	45750	GHELA	312723.74	126	31-03-21
52	83231	GHELA	31685.58	125	31-03-21
53	73842	BHANI	804211.45	120	31-03-21
54	99892	BHANI	701075	120	31-03-21
55	73705	NGALA	29815.42	120	31-03-21
56	11482	ONIYA	0	104	31-03-21
57	79264	NAGAR	98762.32	126	31-03-21
58	67051	YUNUS	353875	102	31-03-21
59	79530	TECHA	2776575	126	31-03-21
60	80524	TECHA	1604360	120	31-03-21
61	22075	ASARA	507669	102	31-03-21
62	72642	JGURU	1235048	120	31-03-21
63	35360	JGURU	78396	125	31-03-21
64	80110	JGURU	351327.08	126	31-03-21
65	59424	UKHBH	2709168	128	31-03-21
66	83484	UKHBH	130121	125	31-03-21
67	15781	ADIYA	3911712	120	31-03-21
68	30032	ADIYA	319748	126	31-03-21
69	27601	ujara	30898.02	125	31-03-21
70	42101	ujara	548429.48	126	31-03-21
71	20834	ujara	1963010	120	31-03-21
72	76186	IRANI	0	120	08-04-21
73	73655	IRANI	0	125	08-04-21
74	76471	IRANI	0	125	08-04-21
75	73600	IRANI	0	120	08-04-21
76	59212	VADIA	0	104	08-04-21
77	59507	ALANI	185262.67	120	08-04-21
78	77846	ANIAR	607625	122	08-04-21
79	31746	UBHAI	103202	125	08-04-21
80	76012	LANKI	1279590	120	08-04-21
81	76933	LANKI	294446.63	126	08-04-21
82	68075	AKRAR	322011.65	120	08-04-21
83	61837	RDIYA	61014.85	125	08-04-21
84	61565	RDIYA	1904218	120	08-04-21
85	8997	ARIYA	2698576	120	08-04-21
86	62506	ARMAR	975216.42	120	08-04-21
87	14041	ARMAR	0	125	08-04-21
88	50662	ATHOD	188730	120	08-04-21
89	95153	MECHA	50980.34	120	08-04-21
90	45386	RAVAT	0	104	08-04-21
91	81322	HNABH	1205726.97	120	08-04-21
92	86175	HNABH	22454.85	125	08-04-21
93	95596	BIND	2134483	120	08-04-21
94	10916	BIND	424941	126	08-04-21
95	32981	BIND	55295	125	08-04-21
96	20108	ATHOD	3442682.94	126	08-04-21
97	42906	ATHOD	6007779	120	08-04-21
98	12292	abhai	764329.08	126	08-04-21
99	94882	abhai	2180116	120	08-04-21
100	54720	SVAMI	46196.14	125	08-04-21
101	14038	SVAMI	1412560	128	08-04-21
102	72436	VORA	4053205	120	08-04-21
103	8403	VORA	49998.8	125	08-04-21
104	92912	VORA	1791712.33	126	08-04-21
105	99087	ANLAL	1435905.13	120	08-04-21
106	39503	ANLAL	1280162.05	126	08-04-21
107	13067	KUMAR	28162.13	125	08-04-21
108	88077	KUMAR	474837.59	120	08-04-21
109	24036	NERIA	296554.66	120	08-04-21
110	93392	RBHAI	732567.15	120	08-04-21
111	97431	MANBH	205614.5	126	08-04-21
112	89260	MANBH	751992.62	120	08-04-21
113	16257	JOSHI	556392	128	08-04-21
114	81822	JOSHI	13141	125	08-04-21
115	36324	YSINH	162331	104	08-04-21
116	44170	HBHAI	9639	125	08-04-21
117	38463	HBHAI	597066	120	08-04-21
118	46432	TANNA	1363495.07	126	08-04-21
119	40910	TANNA	927887.64	120	08-04-21
120	75011	HDIYA	1795491	128	08-04-21
121	93539	HDIYA	55098	125	08-04-21
122	49007	UBHAI	469638.61	126	08-04-21
123	41348	UBHAI	1315783	120	08-04-21
124	6369	nbhai	2241935.61	126	08-04-21
125	86239	nbhai	3265005	120	08-04-21
126	14621	nbhai	245601	125	08-04-21
127	61317	ELIYA	196349	104	08-04-21
128	21658	ADIYA	3492251.91	120	08-04-21
129	67671	ADIYA	219457.09	125	08-04-21
130	4475	ADIYA	2321727.36	126	08-04-21
131	75259	ADIYA	5450.04	125	08-04-21
132	97810	ADIYA	84498.84	120	08-04-21
133	43806	BHATT	106526.15	104	08-04-21
134	60228	RAVI	775923.57	102	08-04-21
135	79535	RAOL	3169751	120	08-04-21
136	91964	RAVAL	1694467	120	08-04-21
137	66797	KWANA	354282.53	120	08-04-21
138	35063	HBHAI	873635	102	08-04-21
139	15036	RBHAI	505292.06	126	08-04-21
140	2923	RBHAI	781374	120	08-04-21
141	45858	khani	199080	126	08-04-21
142	26969	khani	941877	120	08-04-21
143	34818	khani	19076.52	125	08-04-21
144	3244	IMOD	65365.56	120	08-04-21
145	68481	AUHAN	329058.61	126	08-04-21
146	25204	AUHAN	131414.92	125	08-04-21
147	39798	AUHAN	2271005.51	120	08-04-21
148	83231	GHELA	25458.58	125	08-04-21
149	26623	GHELA	1362217	120	08-04-21
150	45750	GHELA	306754.74	126	08-04-21
151	73842	BHANI	804211.45	120	08-04-21
152	99892	BHANI	701075	120	08-04-21
153	92494	LYANA	299	125	08-04-21
154	14559	LYANA	536659.22	120	08-04-21
155	74833	HAGDE	1029385.07	126	08-04-21
156	81991	HAGDE	515049	126	08-04-21
157	29278	HAGDE	1827307	120	08-04-21
158	9584	HAGDE	99223	125	08-04-21
159	11482	ONIYA	0	104	08-04-21
160	54859	GRAJI	737237.57	120	08-04-21
161	73705	NGALA	27315.42	120	08-04-21
162	80524	TECHA	1018549	120	08-04-21
163	79530	TECHA	2776575	126	08-04-21
164	67051	YUNUS	353875	102	08-04-21
165	46340	TVANI	3031396.07	120	08-04-21
166	27102	HAKAR	305594.4	102	08-04-21
167	79264	NAGAR	93492.32	126	08-04-21
168	15781	ADIYA	3911712	120	08-04-21
169	30032	ADIYA	319748	126	08-04-21
170	47097	IYARA	963535.69	120	08-04-21
171	93273	IYARA	20418.63	125	08-04-21
172	60630	IYARA	630381	126	08-04-21
173	97226	VRANI	42977.76	125	08-04-21
174	96082	VRANI	2015353.29	120	08-04-21
175	12635	VRANI	1121303	126	08-04-21
176	83484	UKHBH	130121	125	08-04-21
177	59424	UKHBH	2709168	128	08-04-21
178	22075	ASARA	507669	102	08-04-21
179	27601	ujara	30580	125	08-04-21
180	42101	ujara	541160	126	08-04-21
181	20834	ujara	1963010	120	08-04-21
182	80110	JGURU	351327.08	126	08-04-21
183	72642	JGURU	1235048	120	08-04-21
184	35360	JGURU	78396	125	08-04-21
185	77846	ANIAR	607625	122	11-04-21
186	59507	ALANI	185262.67	120	11-04-21
187	76933	LANKI	294446.63	126	11-04-21
188	76012	LANKI	1279590	120	11-04-21
189	31746	UBHAI	103202	125	11-04-21
190	73600	IRANI	0	120	11-04-21
191	73655	IRANI	0	125	11-04-21
192	76186	IRANI	0	120	11-04-21
193	76471	IRANI	0	125	11-04-21
194	59212	VADIA	0	104	11-04-21
195	8997	ARIYA	2698576	120	11-04-21
196	68075	AKRAR	322011.65	120	11-04-21
197	61565	RDIYA	1904218	120	11-04-21
198	61837	RDIYA	61014.85	125	11-04-21
199	50662	ATHOD	188730	120	11-04-21
200	95153	MECHA	50980.34	120	11-04-21
201	14041	ARMAR	0	125	11-04-21
202	62506	ARMAR	975216.42	120	11-04-21
203	26736	GDISH	722982.95	126	11-04-21
204	9324	GDISH	1104871.45	120	11-04-21
205	23910	GDISH	20904.32	125	11-04-21
206	45386	RAVAT	0	104	11-04-21
207	20108	ATHOD	3442682.94	126	11-04-21
208	42906	ATHOD	6007779	120	11-04-21
209	86175	HNABH	22454.85	125	11-04-21
210	81322	HNABH	1205726.97	120	11-04-21
211	95596	BIND	2134483	120	11-04-21
212	32981	BIND	55295	125	11-04-21
213	10916	BIND	424941	126	11-04-21
214	12292	abhai	764329.08	126	11-04-21
215	94882	abhai	2180116	120	11-04-21
216	54720	SVAMI	46196.14	125	11-04-21
217	14038	SVAMI	1412560	128	11-04-21
218	99087	ANLAL	1435905.13	120	11-04-21
219	39503	ANLAL	1280162.05	126	11-04-21
220	92912	VORA	1791712.33	126	11-04-21
221	8403	VORA	49998.8	125	11-04-21
222	72436	VORA	4053205	120	11-04-21
223	88077	KUMAR	474837.59	120	11-04-21
224	13067	KUMAR	28162.13	125	11-04-21
225	24036	NERIA	296554.66	120	11-04-21
226	93392	RBHAI	732567.15	120	11-04-21
227	97431	MANBH	205614.5	126	11-04-21
228	89260	MANBH	751992.62	120	11-04-21
229	81822	JOSHI	13141	125	11-04-21
230	16257	JOSHI	556392	128	11-04-21
231	38463	HBHAI	597066	120	11-04-21
232	44170	HBHAI	9639	125	11-04-21
233	36324	YSINH	162331	104	11-04-21
234	40910	TANNA	927887.64	120	11-04-21
235	46432	TANNA	1363495.07	126	11-04-21
236	61317	ELIYA	196349	104	11-04-21
237	41348	UBHAI	1315783	120	11-04-21
238	49007	UBHAI	469638.61	126	11-04-21
239	86239	nbhai	3265005	120	11-04-21
240	14621	nbhai	245601	125	11-04-21
241	6369	nbhai	2241935.61	126	11-04-21
242	93539	HDIYA	55098	125	11-04-21
243	75011	HDIYA	1795491	128	11-04-21
244	67671	ADIYA	219457.09	125	11-04-21
245	4475	ADIYA	2321727.36	126	11-04-21
246	21658	ADIYA	3492251.91	120	11-04-21
247	35063	HBHAI	873635	102	11-04-21
248	79535	RAOL	3169751	120	11-04-21
249	66797	KWANA	354282.53	120	11-04-21
250	79995	HUKLA	202755.85	126	11-04-21
251	7797	HUKLA	626558.16	128	11-04-21
Sheet1