macro count items for duplicate names and merge values

[Mussa]

hi
I want macro count the invoices in COL C for duplicate names in COL B and merge the values in COL E.
the result should show from COL K: M

ARRANGE.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	DATE	NAME	INVOICE NO	ORDER NO	TOTAL						NAME	COUNT INVOICES	TOTAL
2	1/1/2021	KALL1	INV1000	RD1000	2,000.00						KALL1	3	5,500.00
3	1/2/2021	KALL2	INV1001	RD1001	3,000.00						KALL2	2	5,500.00
4	1/3/2021	KALL3	INV1002	RD1002	4,000.00						KALL3	2	7,500.00
5	1/4/2021	KALL4	INV1003	RD1003	5,000.00						KALL4	2	7,500.00
6	1/5/2021	KALL5	INV1004	RD1004	6,000.00						KALL5	2	7,500.00
7	1/6/2021	KALL6	INV1005	RD1005	2,500.00						KALL6	2	4,000.00
8	1/7/2021	KALL7	INV1006	RD1006	4,500.00						KALL7	2	6,000.00
9	1/8/2021	KALL8	INV1007	RD1007	3,500.00						KALL8	2	5,000.00
10	1/9/2021	KALL9	INV1008	RD1008	1,000.00						KALL9	2	2,500.00
11	1/10/2021	KALL1	INV1009	RD1009	2,000.00
12	1/11/2021	KALL2	INV1010	RD1010	2,500.00
13	1/12/2021	KALL3	INV1011	RD1011	3,500.00
14	1/13/2021	KALL4	INV1012	RD1012	2,500.00
15	1/14/2021	KALL5	INV1013	RD1013	1,500.00
16	1/15/2021	KALL6	INV1014	RD1014	1,500.00
17	1/16/2021	KALL7	INV1015	RD1015	1,500.00
18	1/17/2021	KALL8	INV1016	RD1016	1,500.00
19	1/18/2021	KALL9	INV1017	RD1017	1,500.00
20	1/19/2021	KALL1	INV1018	RD1018	1,500.00
21
SHEET1

 

[JamesCanale]

without a macro:

MrExcelPlayground4.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	DATE	NAME	INVOICE NO	ORDER NO	TOTAL						NAME	COUNT INVOICES	TOTAL
2	1/1/2021	KALL1	INV1000	RD1000	2000						KALL1	3	$5,500.00
3	1/2/2021	KALL2	INV1001	RD1001	3000						KALL2	2	$5,500.00
4	1/3/2021	KALL3	INV1002	RD1002	4000						KALL3	2	$7,500.00
5	1/4/2021	KALL4	INV1003	RD1003	5000						KALL4	2	$7,500.00
6	1/5/2021	KALL5	INV1004	RD1004	6000						KALL5	2	$7,500.00
7	1/6/2021	KALL6	INV1005	RD1005	2500						KALL6	2	$4,000.00
8	1/7/2021	KALL7	INV1006	RD1006	4500						KALL7	2	$6,000.00
9	1/8/2021	KALL8	INV1007	RD1007	3500						KALL8	2	$5,000.00
10	1/9/2021	KALL9	INV1008	RD1008	1000						KALL9	2	$2,500.00
11	1/10/2021	KALL1	INV1009	RD1009	2000
12	1/11/2021	KALL2	INV1010	RD1010	2500
13	1/12/2021	KALL3	INV1011	RD1011	3500
14	1/13/2021	KALL4	INV1012	RD1012	2500
15	1/14/2021	KALL5	INV1013	RD1013	1500
16	1/15/2021	KALL6	INV1014	RD1014	1500
17	1/16/2021	KALL7	INV1015	RD1015	1500
18	1/17/2021	KALL8	INV1016	RD1016	1500
19	1/18/2021	KALL9	INV1017	RD1017	1500
20	1/19/2021	KALL1	INV1018	RD1018	1500
Sheet11

Cell Formulas
Range	Formula
K2:K19	K2	=IFERROR(INDEX($B$2:$B$20,MATCH(0,COUNTIF($K$1:K1,$B$2:$B$20),0)),"")
L2:L19	L2	=IF(K2<>"",COUNTIF($B$2:$B$20,K2),"")
M2:M19	M2	=IF(K2<>"",SUMPRODUCT(--($B$2:$B$20=K2),$E$2:$E$20),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Mussa]

thanks for the formula is good choice , but in my case is not.

without a macro:

you see my picture is simple data . in reality is about 1000 rows and increases .