How to count duplicate as one?

[feni1388]

Hello everyone...

I have the table as below.

The result that I want to achieve is the one in column B and C.
I want to know how many invoices numbers and how many banks are recorded for one customer code.
I tried using countifs or filter but I couldn't achieve the result that I expected.
Please help.

Thank you in advance.

Book1
	A	B	C	D	E	F	G	H	I
1	Customer Code	Count how many invoice numbers	Count how many banks			Entry date	Invoice No.	Customer Code	Bank Name
2	PX129000	2	1			2025/3/6	168816	PX129000	A Bank
3	PM487000	1	2			2025/3/6	168816	PX129000	A Bank
4	PR662000					2025/3/6	168817	PX129000	A Bank
5	PU269000					2025/3/6	168818	PM487000	A Bank
6	MZS01000					2025/3/6	168818	PM487000	B Bank
7	PV702000					2025/3/6	168819	PR662000	A Bank
8	PI561000					2025/3/6	168820	PU269000	B Bank
9	PV227000					2025/3/6	168821	MZS01000	B Bank
10	TBZ01000					2025/3/6	168822	PV702000	C Bank
11						2025/3/6	168823	PI561000	みずほ銀行
12						2025/3/6	168824	PV227000	みずほ銀行
13						2025/3/6	168825	TBZ01000	みずほ銀行
14
Sheet1

 

[Peter_SSs]

Is this what you are after?
I have assumed that each customer code in col A appears at least once in col H as per your sample.

25 03 07.xlsm
	A	B	C	D	E	F	G	H	I
1	Customer Code	invoice numbers	banks			Entry date	Invoice No.	Customer Code	Bank Name
2	PX129000	2	1			2025/3/6	168816	PX129000	A Bank
3	PM487000	1	2			2025/3/6	168816	PX129000	A Bank
4	PR662000	1	1			2025/3/6	168817	PX129000	A Bank
5	PU269000	1	1			2025/3/6	168818	PM487000	A Bank
6	MZS01000	1	1			2025/3/6	168818	PM487000	B Bank
7	PV702000	1	1			2025/3/6	168819	PR662000	A Bank
8	PI561000	1	1			2025/3/6	168820	PU269000	B Bank
9	PV227000	1	1			2025/3/6	168821	MZS01000	B Bank
10	TBZ01000	1	1			2025/3/6	168822	PV702000	C Bank
11						2025/3/6	168823	PI561000	みずほ銀行
12						2025/3/6	168824	PV227000	みずほ銀行
13						2025/3/6	168825	TBZ01000	みずほ銀行
Count

Cell Formulas
Range	Formula
B2:B10	B2	=ROWS(UNIQUE(FILTER(G$2:G$13,H$2:H$13=A2)))
C2:C10	C2	=ROWS(UNIQUE(FILTER(I2:I13,H$2:H$13=A2)))

 

[feni1388]

Is this what you are after?
I have assumed that each customer code in col A appears at least once in col H as per your sample.

25 03 07.xlsm
	A	B	C	D	E	F	G	H	I
1	Customer Code	invoice numbers	banks			Entry date	Invoice No.	Customer Code	Bank Name
2	PX129000	2	1			2025/3/6	168816	PX129000	A Bank
3	PM487000	1	2			2025/3/6	168816	PX129000	A Bank
4	PR662000	1	1			2025/3/6	168817	PX129000	A Bank
5	PU269000	1	1			2025/3/6	168818	PM487000	A Bank
6	MZS01000	1	1			2025/3/6	168818	PM487000	B Bank
7	PV702000	1	1			2025/3/6	168819	PR662000	A Bank
8	PI561000	1	1			2025/3/6	168820	PU269000	B Bank
9	PV227000	1	1			2025/3/6	168821	MZS01000	B Bank
10	TBZ01000	1	1			2025/3/6	168822	PV702000	C Bank
11						2025/3/6	168823	PI561000	みずほ銀行
12						2025/3/6	168824	PV227000	みずほ銀行
13						2025/3/6	168825	TBZ01000	みずほ銀行
Count

Cell Formulas
Range	Formula
B2:B10	B2	=ROWS(UNIQUE(FILTER(G$2:G$13,H$2:H$13=A2)))
C2:C10	C2	=ROWS(UNIQUE(FILTER(I2:I13,H$2:H$13=A2)))

Thank you so much Peter.
This is exactly what I'm after.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.