COUNTIF WITH UNIQUE COMBINATION

[dannwid]

Hello fellas, I need a little help on countif formula.

I have table with contains No of PO and Vendor Name. Sometimes, some vendors split one PO into 2 or more, hence they appear twice or more.

So, i need to countif every each of vendor by their unique PO. You can see the case in the picture below, I also put the xlsx file.

What combination formula can i use to achieve result in yellow area, with criteria on F4,F5,F6 and so on?

I am hopeful that I describe the case well.

Thank you in advance

EXCEL FILE: DOWNLOAD

 

[dannwid]

That suggests you don't have the groupby function yet.
Try

Case 123.xlsx
	B	C	D	E	F	G
2					formula result goal:
3	PO	VENDORS NAME			VENDOR	Number of POs (unique)
4	123	AAA			AAA	2
5	123	AAA			BBB	1
6	123	AAA			CCC	3
7	123	AAA
8	222	AAA
9	222	AAA
10	333	BBB
11	333	BBB
12	441	CCC
13	442	CCC
14	443	CCC
15	443	CCC
16
Sheet1

Cell Formulas
Range	Formula
F4:F6	F4	=UNIQUE(TOCOL(C4:C100,1))
G4:G6	G4	=ROWS(UNIQUE(FILTER($B$4:$B$100,$C$4:$C$100=F4)))
Dynamic array formulas.

I think this is the best solution. Thanks Fluff.

 

[Fluff]

Glad we could help & thanks for the feedback.