Find Matching SKU and Item Numbers

[i8ur4re]

Hi,

I have an excel sheet that has around 5000 products, i have 2 columns that are Code (C) and SKU (D), I would like to generate a report that tells me what items are duplicate. I would use the SKU to find identical SKU's so i can remove them from our system and i would also look for duplicates in column C which is the codes.

Here is a visual:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]SKU[/TD]
[TD]Price[/TD]
[TD]Cost[/TD]
[TD]Stock Count[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]Chicago[/TD]
[TD]Apple Kit[/TD]
[TD]11223344556[/TD]
[TD]12345[/TD]
[TD]21.95[/TD]
[TD]15.95[/TD]
[TD]23[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]Red Kit[/TD]
[TD]66778899001[/TD]
[TD]67890[/TD]
[TD]15.95[/TD]
[TD]10.95[/TD]
[TD]16[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


Somewhere along the 5000 items, I might have duplicates. I cant search SKU and Code against each other, because that wont make sense, so i would need to generate a report for SKU's and Codes, find duplicates and delete. One more thing, Some SKU's look like this 12345-1, I would like to be able to create a list that can find 12345 and 12345-1. Similar items, just a different variation. Is this possible to do, VB is welcomed.

Thank you

 

[James006]

Hi,

You can insert a Pivot Table ... and get your report ...in less than ten seconds ... :wink:

 

[i8ur4re]

Hi,

You can insert a Pivot Table ... and get your report ...in less than ten seconds ... :wink:

Can you show me how to do that, I am a total noob at excel. Please and thank you. Much appreciated.

 

[James006]

Hi again,

An excellent explanation is Debra's ...!!!

https://www.contextures.com/xlPivot01.html

Hope this will help