how many counts per month

[AYSHANA]

good day!

I would like to count how many (not received acc) was converted to (cancelled acc) per month.
thank you.

Book2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	NOT RECEIVED SAMPLE			CANCELLED SAMPLE
2	Acc No#	DATE		Acc No#	DATE
3	W525280	01/03/2023		W512730	01/03/2023		2023
4	W530371	01/03/2023		W519733	01/03/2023
5	W533842	01/03/2023		H463159	02/03/2023		JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE
6	W534404	03/03/2023		H468729	02/03/2023
7	X352801	05/03/2023		H477651	02/03/2023
8	X353807	05/03/2023		T19193	02/03/2023
9	X354669	05/03/2023		W530371	02/03/2023
10	T33650	07/03/2023		W534661	02/03/2023
11	W538377	08/03/2023		F433824	03/03/2023
12	W556856	08/03/2023		W534404	03/03/2023
13	H485934	09/03/2023		T20084	05/03/2023
14	X363204	12/03/2023		X345494	05/03/2023
15	M408731	13/03/2023		X349863	05/03/2023
16	M412476	13/03/2023		X353382	05/03/2023
17	W567875	15/03/2023		X353598	05/03/2023
18	H508917	16/03/2023		X354657	05/03/2023
19	S485685	18/03/2023		M382049	06/03/2023
20	S487245	18/03/2023		M394202	06/03/2023
21	S488723	18/03/2023		M396887	06/03/2023
22	M433795	20/03/2023		M401118	06/03/2023
23	T99568	21/03/2023		T52695	07/03/2023
24	F477450	24/03/2023		T52707	07/03/2023
25	S499254	25/03/2023		T52833	07/03/2023
26	X375874	26/03/2023		X318296	07/03/2023
27	M459276	27/03/2023		W536305	08/03/2023
28	W619712	29/03/2023		W545559	08/03/2023
29				H485809	09/03/2023
30				H506073	09/03/2023
31				W556856	09/03/2023
32				X353807	09/03/2023
33				F450435	10/03/2023
34				H445686	10/03/2023
35				X297811	12/03/20223
36				M410178	13/02/2023
37				M428665	13/02/2023
38				T57101	14/03/2023
39				T76481	14/03/2023
40				T77301	14/03/2023
41				W576114	15/03/2023
42				H507961	16-03-2023
43				H508031	16-03-2023
44				H508173	16-03-2023
45				H508908	16-03-2023
46				H530309	16-03-2023
47				W525280	16-03-2023
48				W578033	16-03-2023
49				W578035	16-03-2023
50				F461842	17/03/2023
51				H524678	17/03/2023
52				T792836	17/03/2023
53				S485146	18/03/2023
54				M436162	20/03/2023
55				M447577	20/03/2023
56				M451762	20/03/2023
57				M451766	20/03/2023
58				S488723	21/03/2023
59				W583470	22/03/2023
60				W600220	22/03/2023
61				H546573	25/03/2023
62				F469168	24/03/2023
63				F478839	24/03/2023
64				F479378	24/03/2023
65				S498812	25/03/2023
66				M408731	26/03/2023
67				M412476	26/03/2023
68				X374898	26/03/2023
69				X375344	26/03/2023
70				H232170	27/03/2023
71				M459158	27/03/2023
72				M469112	27/03/2023
73				M471481	27/03/2023
74				T111598	28/03/2023
75				H508917	29/03/2023
76				T33650	29/03/2023
77				W618597	29/03/2023
78				W618598	29/03/2023
79				W619353	29/03/2023
80				X354669	29/03/2023
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D80,A3:A27	Cell Value	duplicates	text	NO

 

[ranman256]

your data is stored wrong. You want all data in 3 columns:

ACCT, DATE, STATUS
wabc, 1/1/2023, NOT RECV
wxyz, 1/1/2023, CANCEL


then make pivot table for your stats.

 

[AYSHANA]

i cant do a pivot table
because am receiving a daily report so im copy pasting the report in another excel