Query: How to count same party with unique Invoice numbers....

[krunal123]

like ... "SR FOODS LTD" two time make Purchase products.
1) how to count target Unique Invoice Number With same party Name ???????????????????????????????????????????????

 

[sandy666]

like this?

Party Name	Invoice NO.	Count	Qty
SR FOODS LTD	EXP/01/20-21	4	90
BLOOM JR LTD	EXP/03/20-21	3	45
SR FOODS LTD	EXP/025/20-21	4	240
RJ FEMA FOODS LTD	EXP/045/20-21	1	100

or

Party Name	Invoice NO.	Count	Product	Qty
SR FOODS LTD	EXP/01/20-21	4	BISCUIT	90
SR FOODS LTD	EXP/01/20-21	4	TOOTHPASTE	90
SR FOODS LTD	EXP/01/20-21	4	RICE	90
SR FOODS LTD	EXP/01/20-21	4	BASMATI RICE	90
BLOOM JR LTD	EXP/03/20-21	3	MASALA	45
BLOOM JR LTD	EXP/03/20-21	3	WHEAT FLOUR	45
BLOOM JR LTD	EXP/03/20-21	3	SWEET CORN	45
SR FOODS LTD	EXP/025/20-21	4	EGG	240
SR FOODS LTD	EXP/025/20-21	4	SANITIZER	240
SR FOODS LTD	EXP/025/20-21	4	COCO POWDER	240
SR FOODS LTD	EXP/025/20-21	4	CHILLI POWDER	240
RJ FEMA FOODS LTD	EXP/045/20-21	1	FACE POWDER	100

 

[krunal123]

Ya pleased show formula sir ...................

 

[sandy666]

this is Power Query not any formula but you didn't answer which one you want

 

[Fluff]

With formulae

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1	Party Name	Invoice NO.	Count	Product	Qty			Party Name
2	SR FOODS LTD	EXP/01/20-21	4	BISCUIT	90			SR FOODS LTD	2
3	SR FOODS LTD	EXP/01/20-21	4	TOOTHPASTE	90			BLOOM JR LTD	1
4	SR FOODS LTD	EXP/01/20-21	4	RICE	90			RJ FEMA FOODS LTD	1
5	SR FOODS LTD	EXP/01/20-21	4	BASMATI RICE	90
6	BLOOM JR LTD	EXP/03/20-21	3	MASALA	45
7	BLOOM JR LTD	EXP/03/20-21	3	WHEAT FLOUR	45
8	BLOOM JR LTD	EXP/03/20-21	3	SWEET CORN	45
9	SR FOODS LTD	EXP/025/20-21	4	EGG	240
10	SR FOODS LTD	EXP/025/20-21	4	SANITIZER	240
11	SR FOODS LTD	EXP/025/20-21	4	COCO POWDER	240
12	SR FOODS LTD	EXP/025/20-21	4	CHILLI POWDER	240
13	RJ FEMA FOODS LTD	EXP/045/20-21	1	FACE POWDER	100
14
Master

Cell Formulas
Range	Formula
H2:H4	H2	=UNIQUE(A2:A13)
I2:I4	I2	=ROWS(UNIQUE(FILTER(B2:B13,A2:A13=H2)))
Dynamic array formulas.