count duplicate rows

[msnewtothis]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product

[/TD]
[TD]Lot

[/TD]
[TD]Exp
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]X
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]X
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]Y
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]Y
[/TD]
[/TR]
</tbody>[/TABLE]

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

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Product[/td][td=bgcolor:#5B9BD5]Lot[/td][td=bgcolor:#5B9BD5]Exp[/td][td][/td][td=bgcolor:#70AD47]Product[/td][td=bgcolor:#70AD47]Lot[/td][td=bgcolor:#70AD47]Exp[/td][td=bgcolor:#70AD47]Count[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]A[/td][td=bgcolor:#DDEBF7]

1​

[/td][td=bgcolor:#DDEBF7]X[/td][td][/td][td=bgcolor:#E2EFDA]A[/td][td=bgcolor:#E2EFDA]

1​

[/td][td=bgcolor:#E2EFDA]X[/td][td=bgcolor:#E2EFDA]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]A[/td][td]

1​

[/td][td]X[/td][td][/td][td]A[/td][td]

2​

[/td][td]Y[/td][td]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]A[/td][td=bgcolor:#DDEBF7]

2​

[/td][td=bgcolor:#DDEBF7]Y[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]A[/td][td]

2​

[/td][td]Y[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

[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]