count duplicate rows

[msnewtothis]

Product	Lot	Exp
A	1	X
A	1	X
A	2	Y
A	2	Y

<tbody>
</tbody>

need function that will allow me to count different products with different lots from a list.

 

[CyrusTheVirus]

What are your expected results? Can you please show them?

 

[msnewtothis]

Product Lot Exp Qty
A 1 x 2
A 2 y 2

we barcode in our inventory and I need to be able to have a count of each product we receive and which how many of each lot.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1	Product	Lot	Exp
2	A	1	X	2
3	A	1	X	2
4	A	2	Y	2
5	A	2	Y	2
Booking Data

Cell Formulas
Range	Formula
D2	=COUNTIFS($A$2:$A$5,A2,$B$2:$B$5,B2)

 

[sandy666]

or with PowerQuery

Product	Lot	Exp		Product	Lot	Exp	Count
A	1​	X		A	1​	X	2​
A	1​	X		A	2​	Y	2​
A	2​	Y
A	2​	Y

[SIZE=1]// Table3
let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Group = Table.Group(Source, {"Product", "Lot", "Exp"}, {{"Count", each Table.RowCount(_), type number}})
in
    Group[/SIZE]