Forum Discussion
Solved
Cross search matching data - SOLVED
My employer asked me to automate the duplicate positioned items in excel. Our company works with 20.000+ items and the stock in all of the locations is automatically updated each day. When new items ...
Assuming that the layout is as in your second example: Branch in column A, Item in column B, and Locations 1 to 9 in columns C to K:
Enter a heading such as Duplicate in L1.
Enter the following formula in L2:
=COUNTIFS(A:A,A2,C:C,C2,D:D,D2,E:E,E2,F:F,F2,G:G,G2,H:H,H2,I:I,I2,J:J,J2,K:K,K2)>1Fill down to the end of the data.
You can now turn on AutoFilter, and filter column L for TRUE.
Assuming that the layout is as in your second example: Branch in column A, Item in column B, and Locations 1 to 9 in columns C to K:
Enter a heading such as Duplicate in L1.
Enter the following formula in L2:
=COUNTIFS(A:A,A2,C:C,C2,D:D,D2,E:E,E2,F:F,F2,G:G,G2,H:H,H2,I:I,I2,J:J,J2,K:K,K2)>1Fill down to the end of the data.
You can now turn on AutoFilter, and filter column L for TRUE.
HansVogelaar Thank you, this solves it!
