Duplicate

[Hussein982]

Hi Folks, this may be a simple question..

I have an excel record that contains thousands of line items in which I would like to identify the duplicate item numbers that has the SAME Sub-inventory.

The output of the workflow should catch the first 4 records given that they have the same item number and the same sub inventory. 

Appreciate a workflow if this can be provide. 

Cheers,

H.

Record #	Sub inventory	Item Number
1	Staging	12
2	Staging	12
3	Principal warehouse	13
4	Principal warehouse	13
5	Warehouse 2	14
6	Warehouse 3	15
7	Warehouse 4	16

[flying008 · Accepted solution]

Hi, @Hussein982 

FYI. If  the duplicate item numbers > 3 or more.

Input
Record #	Sub inventory	Item Number
1	Staging	12
2	Staging	12
3	Principal warehouse	13
4	Principal warehouse	13
5	Warehouse 2	14
6	Warehouse 3	15
7	Warehouse 4	16
8	Staging	12
Output
Record #	Sub inventory	Item Number	Group
1	Staging	12	-1
2	Staging	12	-1
3	Principal warehouse	13	-1
4	Principal warehouse	13	-1
5	Warehouse 2	14	0
6	Warehouse 3	15	0
7	Warehouse 4	16	0
8	Staging	12	-1

[Qiu · Accepted solution]

@Hussein982 
We can use the Mult-row formula to check if the "item numbers" and "Sub-inventory" are same with its last row or next row.

[Hussein982]

Thank you so much for the help. Solved and replied perfectly my question.

[Hussein982]

Thank you and this was a big help.

[bivu]