Creating a table to help remove duplicates

[divster27]

I have a table of data with 3 columns:

Title (Duplicate data - 2 or 3 duplicates, maybe 4)
Item number (Unique)
Current Price - Sometimes the same, sometimes one is the lowest

Column D shows what i want to have returned - it will either be End, or just left blank
Column E shows the reason for keeping or ending - to keep, it will either be because it's the lowest price, or the lowest ID number

Hope this makes sense
David

 

[divster27]

two different results: base on smallest ID or last smallest value

Book1
	A	B	C	D	E
1	Title	Item number	Current price	Base on last min value in C	Base on smallest ID in B
2	(DOLCH) NACHT (SKY BLUE VINYL) LP New 4250936533011	166684505068	46.99	End	End
3	(DOLCH) NACHT (SKY BLUE VINYL) LP New 4250936533011	145710032435	46.99	End	End
4	(DOLCH) NACHT (SKY BLUE VINYL) LP New 4250936533011	145706926836	46.99
5	(DOLCH) NACHT CD New 4250936533004	166699590177	26.99	End	End
6	(DOLCH) NACHT CD New 4250936533004	166695963006	26.99	End	End
7	(DOLCH) NACHT CD New 4250936533004	145699232071	26.99
8	(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 0192641821349	166699580374	18.99	End	End
9	(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 0192641821349	166684367749	18.99
10	(HED) P.E. TRUTH RISING CD New 0673951021327	145699232098	18.99	End
11	(HED) P.E. TRUTH RISING CD New 0673951021327	145706892977	18.99	End	End
12	(HED) P.E. TRUTH RISING CD New 0673951021327	145710009763	18.99		End
13	(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA	166699588514	23.99	End	End
14	(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA	166684515837	23.99	End	End
15	(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA	145706906636	23.99
16	(MISS) JACKIE MOORE WHO TOLD YOU 7 New 0029667021876	166699594695	19.99	End	End
17	(MISS) JACKIE MOORE WHO TOLD YOU 7 New 0029667021876	166684506264	19.99	End	End
18	(MISS) JACKIE MOORE WHO TOLD YOU 7 New 0029667021876	145706930954	19.99
19	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 7019662725766	166684515618	15.99	End	End
20	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 7019662725766	145706897104	15.99	End
21	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 7019662725766	145710023577	15.99		End
22	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 7019777725767	166699599622	24.99	End	End
23	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 7019777725767	166684505037	24.99	End	End
24	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 7019777725767	145706925930	24.99
25	10,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 0819514011415	166699586261	17.99	End	End
26	10,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 0819514011415	166684515852	17.99	End
27	10,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 0819514011415	166695972949	17.99		End
28	10,000 MANIACS IN THE CITY OF ANGELS CD New 0823564671628	166695975838	13.99	End	End
29	10,000 MANIACS IN THE CITY OF ANGELS CD New 0823564671628	145699232114	13.99	End
30	10,000 MANIACS IN THE CITY OF ANGELS CD New 0823564671628	145710015227	13.99		End
31	10,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 5292317804616	166699591853	20.99	End	End
32	10,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 5292317804616	166684515858	20.99	End	End
33	10,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 5292317804616	145706910269	20.99
34	100 MILE HOUSE HIRAETH LP New 0842736001018	166695997879	32.99	End	End
35	100 MILE HOUSE HIRAETH LP New 0842736001018	166699597256	32.99	End	End
36	100 MILE HOUSE HIRAETH LP New 0842736001018	145699221022	32.99
37	100 MILE HOUSE LOVE AND LEAVE YOU LP New 0842736001513	145699221019	27.99	End
38	100 MILE HOUSE LOVE AND LEAVE YOU LP New 0842736001513	145710030818	27.99	End	End
39	100 MILE HOUSE LOVE AND LEAVE YOU LP New 0842736001513	145706930121	27.99		End
40	107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 0710473184236	166699583231	19.99	End	End
41	107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 0710473184236	166695964471	19.99	End	End
42	107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 0710473184236	166684515853	19.99
43	1349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 7072805002209	166699599681	34.99	End	End
44	1349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 7072805002209	166695997366	34.99	End	End
45	1349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 7072805002209	166684500104	34.99
46	1349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 707280	166695997351	34.99	End	End
47	1349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 707280	145699221028	34.99	End
48	1349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 707280	145710033951	34.99		End
49	1349 RYKKINN BROWN RING OF FURY CD New 7035538883279	166699592759	20.99	End	End
50	1349 RYKKINN BROWN RING OF FURY CD New 7035538883279	166695968424	20.99	End	End
51	1349 RYKKINN BROWN RING OF FURY CD New 7035538883279	145699232113	20.99
52	1349 SLAVES 7 New 7090014389201	145699221887	19.99	End
53	1349 SLAVES 7 New 7090014389201	145710034164	19.99	End	End
54	1349 SLAVES 7 New 7090014389201	145706933377	19.99		End
55	13TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 0803341553729	166699596580	28.99	End	End
56	13TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 0803341553729	166695991268	28.99	End	End
57	13TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 0803341553729	166684500113	28.99
58	1476 IN EXILE CD New 0884388868762	166699587749	20.99	End	End
59	1476 IN EXILE CD New 0884388868762	166684515849	20.99
60	16 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 0745860737993	166684505045	29.99	End	End
61	16 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 0745860737993	145710029130	29.99	End	End
62	16 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 0745860737993	145706929049	29.99
63	16 / GRIME DOOM SESSIONS VOL. 3 CD New 0745860737979	166684515854	18.99	End	End
64	16 / GRIME DOOM SESSIONS VOL. 3 CD New 0745860737979	145706900928	18.99	End
65	16 / GRIME DOOM SESSIONS VOL. 3 CD New 0745860737979	145710010762	18.99		End
66	16 / GRIME DOOM SESSIONS VOL. 3 LP New 0745860737986	166699596117	24.99	End	End
67	16 / GRIME DOOM SESSIONS VOL. 3 LP New 0745860737986	166695995883	24.99	End	End
68	16 / GRIME DOOM SESSIONS VOL. 3 LP New 0745860737986	145699221032	24.99
69	17 CRASH STAMINA CD New 8051128622089	166699594124	24.99	End	End
70	17 CRASH STAMINA CD New 8051128622089	166695961536	24.99	End	End
71	17 CRASH STAMINA CD New 8051128622089	145699232109	24.99
72	1782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 0745860737481	166695966804	18.99	End	End
73	1782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 0745860737481	145699232092	18.99	End
74	1782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 0745860737481	145710010757	18.99		End
75	1782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 0610371804864	145699221025	29.99	End
76	1782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 0610371804864	145710027291	29.99		End
77	1782 CLAMOR LUCIFERI CD New 0610371804840	145699232112	18.99	End
78	1782 CLAMOR LUCIFERI CD New 0610371804840	145710009038	18.99		End
79	1782 CLAMOR LUCIFERI LP New 0610371804857	166699595196	24.99	End	End
80	1782 CLAMOR LUCIFERI LP New 0610371804857	145699221017	24.99
81	1782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 0647697340721	166699595517	29.99	End	End
82	1782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 0647697340721	166695995748	29.99	End	End
83	1782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 0647697340721	166684505048	29.99
84	1782 FROM THE GRAVEYARD CD New 0647697340707	166699582280	18.99	End	End
85	1782 FROM THE GRAVEYARD CD New 0647697340707	166695965703	18.99	End	End
86	1782 FROM THE GRAVEYARD CD New 0647697340707	145699232108	18.99
87	1782 FROM THE GRAVEYARD LP New 0647697340714	166684505046	24.99	End	End
88	1782 FROM THE GRAVEYARD LP New 0647697340714	145710027863	24.99	End	End
89	1782 FROM THE GRAVEYARD LP New 0647697340714	145706928918	24.99
90	21OCTAYNE 2.0 (LIMITED DIGI) CD New 0884860137829	166684515833	15.99	End	End
91	21OCTAYNE 2.0 (LIMITED DIGI) CD New 0884860137829	166695976251	15.99	End	End
92	21OCTAYNE 2.0 (LIMITED DIGI) CD New 0884860137829	145710016659	15.99
93	21OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 0884860100922	166684515836	15.99	End	End
94	21OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 0884860100922	145706912926	15.99	End
95	21OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 0884860100922	145710016637	15.99		End
96	22 YOU ARE CREATING (2CD) 2CD New 0886922876424	166699588298	24.99	End	End
97	22 YOU ARE CREATING (2CD) 2CD New 0886922876424	166695970503	24.99	End	End
98	22 YOU ARE CREATING (2CD) 2CD New 0886922876424	145699217901	24.99
99	22 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 7090014383599	145710034155	32.99	End	End
100	22 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 7090014383599	166684500293	32.99	End	End
Sheet1

Cell Formulas
Range	Formula
D2:D100	D2	=IF(AGGREGATE(15,6,($C$2:$C$241-ROW($C$2:$C$241)*10^-6)/($A$2:$A$241=A2),1)=C2-ROW(C2)*10^-6,"","End")
E2:E100	E2	=IF(AGGREGATE(15,6,$B$2:$B$241/($A$2:$A$241=A2),1)=B2,"","End")

Hiya - thanks very much, but not quite the answer i'm looking for.
I need to have one column only as i need to use it for uploading

 

[bebo021999]

Hiya - thanks very much, but not quite the answer i'm looking for.
I need to have one column only as i need to use it for uploading

They are for your choice. Use one column only, if it matchs.

 

[divster27]

Maybe something like this.

Sub DoSomething()
    Dim LowAvg As Double, LowVal As Double
    Dim I As Long
    Dim SD As Object
    Dim R As Range, Rng As Range
    Dim Price As String, S As String
    Dim KeyStr As Variant, RefStr As Variant, VA As Variant
    Dim WS As Worksheet
    Dim PrevKey As Variant

    Set WS = ActiveSheet

    With WS
        Set Rng = .Range("A2", .Range("A" & .Rows.Count).End(xlUp))
        Rng.Offset(0, 4).ClearContents
    End With

    Set SD = CreateObject("Scripting.dictionary")

    Application.ScreenUpdating = False
    RefStr = ""
    For Each R In Rng
        KeyStr = R.Value
        RefStr = CStr(R.Offset(0, 2).Value)
        If Not SD.exists(KeyStr) Then
            SD.Add KeyStr, RefStr
        Else
            S = SD.Item(KeyStr)
            S = S & "," & RefStr
            SD.Item(KeyStr) = S
        End If
    Next R

    KeyStr = 0
    For Each KeyStr In SD.Keys
        RefStr = SD.Item(KeyStr)
        If UBound(Split(RefStr, ",")) = 0 Then
            SD.Remove KeyStr
        End If
    Next KeyStr

    For Each R In Rng
        KeyStr = R.Value
        Price = CStr(R.Offset(0, 2).Value)
        R.Offset(0, 4).Value = ""

        If SD.exists(KeyStr) Then
            RefStr = SD.Item(KeyStr)
            VA = Split(RefStr, ",")

            LowVal = CDbl(VA(UBound(VA)))
            LowAvg = 0
            For I = 0 To UBound(VA)
                LowAvg = LowAvg + CDbl(VA(I))
                If CDbl(VA(I)) < LowVal Then
                    LowVal = CDbl(VA(I))
                End If
            Next I
            LowAvg = LowAvg / (UBound(VA) + 1)

            If LowVal <> LowAvg Then
                If CDbl(Price) = LowVal Then
                    R.Offset(0, 4).Value = "Keep this one as it is the lowest of the duplicates"
                Else
                    R.Offset(0, 4).Value = "Duplicate"
                End If
            Else
                If KeyStr <> PrevKey Then
                    R.Select
                    R.Offset(0, 4).Value = "Keep this duplicate (all duplicates have the same price)"
                    PrevKey = KeyStr
                Else
                    R.Select
                    R.Offset(0, 4).Value = "Duplicate"
                End If
            End If
        End If
    Next R

    Application.ScreenUpdating = True
    Set SD = Nothing
End Sub

Hi @rlv01 - sorry to be a pain, but how do i use this code?
Not sure where to put it
David

 

[rlv01]

Hi @rlv01 - sorry to be a pain, but how do i use this code?
Not sure where to put it
David

It is a VBA macro. It must be located in a code module (that you create). It can be activated by using the Excel Alt-F8 menu. If you are unfamiliar with VBA and macros, you might want to start with learning about bit about both.

Excel Macros & VBA - Tutorial for Beginners

The macro is is designed to work with the data format you posted:

Find duplicates for tbleBayAllListings.xlsx
	A	B	C
1	Title	Item number	Current price
2	(DOLCH) NACHT (SKY BLUE VINYL) LP New 4250936533011	166684505068	46.99
3	(DOLCH) NACHT (SKY BLUE VINYL) LP New 4250936533011	145710032435	46.99
4	(DOLCH) NACHT (SKY BLUE VINYL) LP New 4250936533011	145706926836	46.99
5	(DOLCH) NACHT CD New 4250936533004	166699590177	26.99
6	(DOLCH) NACHT CD New 4250936533004	166695963006	26.99
7	(DOLCH) NACHT CD New 4250936533004	145699232071	26.99
8	(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 0192641821349	166699580374	18.99
9	(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 0192641821349	166684367749	18.99
10	(HED) P.E. TRUTH RISING CD New 0673951021327	145699232098	18.99
11	(HED) P.E. TRUTH RISING CD New 0673951021327	145706892977	18.99
12	(HED) P.E. TRUTH RISING CD New 0673951021327	145710009763	18.99
13	(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA	166699588514	23.99
14	(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA	166684515837	23.99
15	(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA	145706906636	23.99
16	(MISS) JACKIE MOORE WHO TOLD YOU 7 New 0029667021876	166699594695	19.99
17	(MISS) JACKIE MOORE WHO TOLD YOU 7 New 0029667021876	166684506264	19.99
18	(MISS) JACKIE MOORE WHO TOLD YOU 7 New 0029667021876	145706930954	19.99
19	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 7019662725766	166684515618	15.99
20	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 7019662725766	145706897104	15.99
21	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 7019662725766	145710023577	15.99
22	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 7019777725767	166699599622	24.99
23	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 7019777725767	166684505037	24.99
24	1/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 7019777725767	145706925930	24.99
25	10,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 0819514011415	166699586261	17.99
26	10,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 0819514011415	166684515852	17.99
27	10,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 0819514011415	166695972949	17.99
28	10,000 MANIACS IN THE CITY OF ANGELS CD New 0823564671628	166695975838	13.99
29	10,000 MANIACS IN THE CITY OF ANGELS CD New 0823564671628	145699232114	13.99
30	10,000 MANIACS IN THE CITY OF ANGELS CD New 0823564671628	145710015227	13.99
31	10,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 5292317804616	166699591853	20.99
32	10,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 5292317804616	166684515858	20.99
33	10,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 5292317804616	145706910269	20.99
34	100 MILE HOUSE HIRAETH LP New 0842736001018	166695997879	32.99
35	100 MILE HOUSE HIRAETH LP New 0842736001018	166699597256	32.99
36	100 MILE HOUSE HIRAETH LP New 0842736001018	145699221022	32.99
37	100 MILE HOUSE LOVE AND LEAVE YOU LP New 0842736001513	145699221019	27.99
38	100 MILE HOUSE LOVE AND LEAVE YOU LP New 0842736001513	145710030818	27.99
39	100 MILE HOUSE LOVE AND LEAVE YOU LP New 0842736001513	145706930121	27.99
40	107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 0710473184236	166699583231	19.99
41	107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 0710473184236	166695964471	19.99
42	107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 0710473184236	166684515853	19.99
43	1349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 7072805002209	166699599681	34.99
44	1349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 7072805002209	166695997366	34.99
45	1349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 7072805002209	166684500104	34.99
46	1349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 707280	166695997351	34.99
47	1349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 707280	145699221028	34.99
48	1349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 707280	145710033951	34.99
49	1349 RYKKINN BROWN RING OF FURY CD New 7035538883279	166699592759	20.99
50	1349 RYKKINN BROWN RING OF FURY CD New 7035538883279	166695968424	20.99
51	1349 RYKKINN BROWN RING OF FURY CD New 7035538883279	145699232113	20.99
52	1349 SLAVES 7 New 7090014389201	145699221887	19.99
53	1349 SLAVES 7 New 7090014389201	145710034164	19.99
54	1349 SLAVES 7 New 7090014389201	145706933377	19.99
55	13TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 0803341553729	166699596580	28.99
56	13TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 0803341553729	166695991268	28.99
57	13TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 0803341553729	166684500113	28.99
58	1476 IN EXILE CD New 0884388868762	166699587749	20.99
59	1476 IN EXILE CD New 0884388868762	166684515849	20.99
60	16 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 0745860737993	166684505045	29.99
61	16 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 0745860737993	145710029130	29.99
62	16 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 0745860737993	145706929049	29.99
63	16 / GRIME DOOM SESSIONS VOL. 3 CD New 0745860737979	166684515854	18.99
64	16 / GRIME DOOM SESSIONS VOL. 3 CD New 0745860737979	145706900928	18.99
65	16 / GRIME DOOM SESSIONS VOL. 3 CD New 0745860737979	145710010762	18.99
66	16 / GRIME DOOM SESSIONS VOL. 3 LP New 0745860737986	166699596117	24.99
67	16 / GRIME DOOM SESSIONS VOL. 3 LP New 0745860737986	166695995883	24.99
68	16 / GRIME DOOM SESSIONS VOL. 3 LP New 0745860737986	145699221032	24.99
69	17 CRASH STAMINA CD New 8051128622089	166699594124	24.99
70	17 CRASH STAMINA CD New 8051128622089	166695961536	24.99
71	17 CRASH STAMINA CD New 8051128622089	145699232109	24.99
72	1782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 0745860737481	166695966804	18.99
73	1782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 0745860737481	145699232092	18.99
74	1782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 0745860737481	145710010757	18.99
75	1782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 0610371804864	145699221025	29.99
76	1782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 0610371804864	145710027291	29.99
77	1782 CLAMOR LUCIFERI CD New 0610371804840	145699232112	18.99
78	1782 CLAMOR LUCIFERI CD New 0610371804840	145710009038	18.99
79	1782 CLAMOR LUCIFERI LP New 0610371804857	166699595196	24.99
80	1782 CLAMOR LUCIFERI LP New 0610371804857	145699221017	24.99
81	1782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 0647697340721	166699595517	29.99
82	1782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 0647697340721	166695995748	29.99
83	1782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 0647697340721	166684505048	29.99
84	1782 FROM THE GRAVEYARD CD New 0647697340707	166699582280	18.99
85	1782 FROM THE GRAVEYARD CD New 0647697340707	166695965703	18.99
86	1782 FROM THE GRAVEYARD CD New 0647697340707	145699232108	18.99
87	1782 FROM THE GRAVEYARD LP New 0647697340714	166684505046	24.99
88	1782 FROM THE GRAVEYARD LP New 0647697340714	145710027863	24.99
89	1782 FROM THE GRAVEYARD LP New 0647697340714	145706928918	24.99
90	21OCTAYNE 2.0 (LIMITED DIGI) CD New 0884860137829	166684515833	15.99
91	21OCTAYNE 2.0 (LIMITED DIGI) CD New 0884860137829	166695976251	15.99
92	21OCTAYNE 2.0 (LIMITED DIGI) CD New 0884860137829	145710016659	15.99
93	21OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 0884860100922	166684515836	15.99
94	21OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 0884860100922	145706912926	15.99
95	21OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 0884860100922	145710016637	15.99
96	22 YOU ARE CREATING (2CD) 2CD New 0886922876424	166699588298	24.99
97	22 YOU ARE CREATING (2CD) 2CD New 0886922876424	166695970503	24.99
98	22 YOU ARE CREATING (2CD) 2CD New 0886922876424	145699217901	24.99
99	22 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 7090014383599	145710034155	32.99
100	22 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 7090014383599	166684500293	32.99
101	22 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 7090014383599	145706931440	32.99
102	22 YOU ARE CREATING 2CD New 7090014383605	166695970508	22.99
103	22 YOU ARE CREATING 2CD New 7090014383605	166684500297	22.99
104	22 YOU ARE CREATING 2CD New 7090014383605	145710023967	22.99
105	22 YOU ARE CREATING: LIMB1 (CLEAR W/GREEN SPOTS VINYL) LP New 7090014393192	166695999849	32.99
106	22 YOU ARE CREATING: LIMB1 (CLEAR W/GREEN SPOTS VINYL) LP New 7090014393192	166684505052	32.99
107	22 YOU ARE CREATING: LIMB1 (CLEAR W/GREEN SPOTS VINYL) LP New 7090014393192	145710034185	32.99
108	23 ACEZ REDEMPTION WAVES CD New 5700907261867	166699592046	18.99
109	23 ACEZ REDEMPTION WAVES CD New 5700907261867	166684515850	18.99
110	23 ACEZ REDEMPTION WAVES CD New 5700907261867	166695977099	18.99
111	24 HEURES AVEC LES LOUPS THE WOLVES CD New 3561302101026	145699232099	23.99
112	24 HEURES AVEC LES LOUPS THE WOLVES CD New 3561302101026	145710017617	23.99
113	24 PESOS BUSTED BROKEN AND BLUE CD New 5060139950831	166684515845	20.99
114	24 PESOS BUSTED BROKEN AND BLUE CD New 5060139950831	166695978666	20.99
115	24 PESOS BUSTED BROKEN AND BLUE CD New 5060139950831	145710021459	20.99
116	24 PESOS WHEN THE SHIP GOES DOWN CD New 5060139950961	166695978670	20.99
117	24 PESOS WHEN THE SHIP GOES DOWN CD New 5060139950961	145699232115	20.99
118	24 PESOS WHEN THE SHIP GOES DOWN CD New 5060139950961	145710021474	20.99
119	24PESOS DO THE RIGHT THING CD New 8800155880654	166699594407	20.99
120	24PESOS DO THE RIGHT THING CD New 8800155880654	166684515848	20.99
121	24PESOS DO THE RIGHT THING CD New 8800155880654	145706912382	20.99
122	2ND FACE UTOPIUM CD New 0884388874077	145699232107	20.99
123	2ND FACE UTOPIUM CD New 0884388874077	145710016507	20.99
124	2PAC RAP & REVOLUTION - INSTRUMENTALS 2LP New 8436022624931	166696000378	24.99
125	2PAC RAP & REVOLUTION - INSTRUMENTALS 2LP New 8436022624931	166699600280	24.99
126	2PAC RAP & REVOLUTION - INSTRUMENTALS 2LP New 8436022624931	145699217755	24.99
127	2RAUMWOHNUNG 20JAHRE 2RAUMWOHNUNG CD New 4250624601275	166699590134	20.99
128	2RAUMWOHNUNG 20JAHRE 2RAUMWOHNUNG CD New 4250624601275	145706903036	20.99
129	2RAUMWOHNUNG 20JAHRE 2RAUMWOHNUNG CD New 4250624601275	145699232106	20.99
130	2RAUMWOHNUNG ACHTUNG FERTIG (EXPANDED EDITION) CD New 4250624600520	166695972715	18.99
131	2RAUMWOHNUNG ACHTUNG FERTIG (EXPANDED EDITION) CD New 4250624600520	145699232110	18.99
132	2RAUMWOHNUNG ACHTUNG FERTIG (EXPANDED EDITION) CD New 4250624600520	145710019668	18.99
133	2RAUMWOHNUNG LASSO CD New 4250624600131	166699590138	18.99
134	2RAUMWOHNUNG LASSO CD New 4250624600131	166684515847	18.99
135	2RAUMWOHNUNG LASSO CD New 4250624600131	166695972726	18.99
136	2RAUMWOHNUNG MELANCHOLISCH SCHÖN CD New 4250624600087	145699232105	18.99
137	2RAUMWOHNUNG MELANCHOLISCH SCHÖN CD New 4250624600087	145706908275	18.99
138	2RAUMWOHNUNG MELANCHOLISCH SCHÖN CD New 4250624600087	145710019664	18.99
139	3 INCHES OF BLOOD HERE WAITS THY DOOM 2LP New 0194111023505	145699217720	32.99
140	3 INCHES OF BLOOD HERE WAITS THY DOOM 2LP New 0194111023505	145710026883	32.99
141	3 INCHES OF BLOOD LONG LIVE HEAVY METAL 2LP New 0194111023512	166699594904	32.99
142	3 INCHES OF BLOOD LONG LIVE HEAVY METAL 2LP New 0194111023512	145699217711	32.99
143	3 SOUNDS, THE HERE WE COME LP New 3700477834777	166699597779	27.99
144	3 SOUNDS, THE HERE WE COME LP New 3700477834777	166684505026	27.99
145	3 SOUNDS, THE HERE WE COME LP New 3700477834777	145706924834	27.99
146	3 SOUNDS, THE INTRODUCING THE 3 SOUNDS LP New 3700477835859	145699221024	27.99
147	3 SOUNDS, THE INTRODUCING THE 3 SOUNDS LP New 3700477835859	145710031528	27.99
148	35 TAPES FABRIC OF TIME CD New 7090039727392	166684515846	23.99
149	35 TAPES FABRIC OF TIME CD New 7090039727392	145710024257	23.99
150	35 TAPES FABRIC OF TIME LP New 7090039727408	166699599985	40.99
151	35 TAPES FABRIC OF TIME LP New 7090039727408	145699221021	40.99
152	35 TAPES HOME CD New 7090039723981	166695965867	20.99
153	35 TAPES HOME CD New 7090039723981	145699232100	20.99
154	35 TAPES HOME CD New 7090039723981	145710024181	20.99
155	35 TAPES HOME LP New 7090039723998	145699221007	32.99
156	35 TAPES HOME LP New 7090039723998	145710034332	32.99
157	35 TAPES HOME LP New 7090039723998	145706928900	32.99
158	36? MILK MOUNTAIN LP New 0724752915787	166695997954	24.99
159	36? MILK MOUNTAIN LP New 0724752915787	166684505025	24.99
160	36? MILK MOUNTAIN LP New 0724752915787	145710028946	24.99
161	37 STABWOUNDS A HEART GONE BLACK CD New 8715392904523	166699594316	13.99
162	37 STABWOUNDS A HEART GONE BLACK CD New 8715392904523	166684515843	13.99
163	37 STABWOUNDS A HEART GONE BLACK CD New 8715392904523	166695980596	13.99
164	3RD & THE MORTAL, THE 2 EP'S (WHITE VINYL) LP New 7072805006450	166699599704	34.99
165	3RD & THE MORTAL, THE 2 EP'S (WHITE VINYL) LP New 7072805006450	145699221016	34.99
166	3RD & THE MORTAL, THE 2 EP'S (WHITE VINYL) LP New 7072805006450	145706929276	34.99
167	3RD & THE MORTAL, THE 2 EP'S LP New 7072805006054	145699221011	32.99
168	3RD & THE MORTAL, THE 2 EP'S LP New 7072805006054	145710033957	32.99
169	3RD & THE MORTAL, THE 2 EP'S LP New 7072805006054	145706929268	32.99
170	3RD & THE MORTAL, THE EP’S & RARITIES CD New 7072805007600	166699592845	21.99
171	3RD & THE MORTAL, THE EP’S & RARITIES CD New 7072805007600	166684515862	21.99
172	3RD & THE MORTAL, THE EP’S & RARITIES CD New 7072805007600	145706899558	21.99
173	3RD & THE MORTAL, THE MEMOIRS (BROWN VINYL) 2LP New 7072805006443	166684500138	43.99
174	3RD & THE MORTAL, THE MEMOIRS (BROWN VINYL) 2LP New 7072805006443	145710033961	43.99
175	3RD & THE MORTAL, THE MEMOIRS (BROWN VINYL) 2LP New 7072805006443	145706929303	43.99
176	3RD & THE MORTAL, THE MEMOIRS 2LP New 7072805006047	166695996148	40.99
177	3RD & THE MORTAL, THE MEMOIRS 2LP New 7072805006047	166684500123	40.99
178	3RD & THE MORTAL, THE MEMOIRS 2LP New 7072805006047	145710033967	40.99
179	3RD & THE MORTAL, THE MEMOIRS CD New 7072805007594	145699232103	21.99
180	3RD & THE MORTAL, THE MEMOIRS CD New 7072805007594	145706899560	21.99
181	3RD & THE MORTAL, THE MEMOIRS CD New 7072805007594	145710023759	21.99
182	3RD & THE MORTAL, THE TEARS LAID IN EARTH CD New 7072805007587	166699592847	21.99
183	3RD & THE MORTAL, THE TEARS LAID IN EARTH CD New 7072805007587	166695964544	21.99
184	3RD & THE MORTAL, THE TEARS LAID IN EARTH CD New 7072805007587	145699232104	21.99
185	3RD ATTEMPT, THE BORN IN THORNS CD New 7090008310952	166684515869	12.99
186	3RD ATTEMPT, THE BORN IN THORNS CD New 7090008310952	145710023824	12.99
187	3RD ATTEMPT, THE EGOCIDAL PATH CD New 7090008311355	145699232129	12.99
188	3RD ATTEMPT, THE EGOCIDAL PATH CD New 7090008311355	145706908348	12.99
189	3RD ATTEMPT, THE EGOCIDAL PATH CD New 7090008311355	145710023845	12.99
190	3RD ATTEMPT, THE EGOCIDAL PATH LP New 7090008319023	166699599817	16.99
191	3RD ATTEMPT, THE EGOCIDAL PATH LP New 7090008319023	166684505033	16.99
192	3RD ATTEMPT, THE EGOCIDAL PATH LP New 7090008319023	145706932073	16.99
193	400 LONELY THINGS MOTHER MOON CD New 0641871746095	166699582165	18.99
194	400 LONELY THINGS MOTHER MOON CD New 0641871746095	166684515867	18.99
195	42 DECIBEL ROLLING IN TOWN (LP+CD) LP New 0886922691713	145699221013	24.99
196	42 DECIBEL ROLLING IN TOWN (LP+CD) LP New 0886922691713	145710031362	24.99
197	42 DECIBEL ROLLING IN TOWN CD New 0886922691720	166684515866	15.99
198	42 DECIBEL ROLLING IN TOWN CD New 0886922691720	145710017098	15.99
199	430 STEPS CITIZEN OF NOTHING LP New 0760137372615	166695996847	32.99
200	430 STEPS CITIZEN OF NOTHING LP New 0760137372615	145699221015	32.99
201	430 STEPS CITIZEN OF NOTHING LP New 0760137372615	145710029323	32.99
202	45 ADAPTERS COLLECTED WORKS (NEON ORANGE VINYL) D10 New 0879198009573	166684505975	27.99
203	45 ADAPTERS COLLECTED WORKS (NEON ORANGE VINYL) D10 New 0879198009573	145710031040	27.99
204	45 ADAPTERS COLLECTED WORKS (NEON ORANGE VINYL) D10 New 0879198009573	145706928614	27.99
205	45 ADAPTERS NOW OR NEVER (DIGITALLY PRINTED 12 INCH) 12 New 0810017645282	145699221625	24.99
206	45 ADAPTERS NOW OR NEVER (DIGITALLY PRINTED 12 INCH) 12 New 0810017645282	145710030148	24.99
207	45 ADAPTERS NOW OR NEVER (DIGITALLY PRINTED 12 INCH) 12 New 0810017645282	145706929129	24.99
208	45 ADAPTERS THEY CALL IT JUSTICE 7 New 0814867023351	166684506267	15.99
209	45 ADAPTERS THEY CALL IT JUSTICE 7 New 0814867023351	145710030321	15.99
210	5 ROYALES Its Hard But Its Fair CD New 0029667006125	166699579113	18.99
211	5 ROYALES Its Hard But Its Fair CD New 0029667006125	166695982986	18.99
212	5 SECONDS OF SUMMER X-POSED CD New 0823564709024	166699586973	8.99
213	5 SECONDS OF SUMMER X-POSED CD New 0823564709024	166684515868	8.99
214	5 SECONDS OF SUMMER X-POSED CD New 0823564709024	166695977669	8.99
215	50 CENT I'M STILL RUNNING THIS CD New 5060330571118	145699232131	15.99
216	50 CENT I'M STILL RUNNING THIS CD New 5060330571118	145706912355	15.99
217	50 CENT I'M STILL RUNNING THIS CD New 5060330571118	145710021553	15.99
218	5IVE YEARS GONE ROCK ‘N’ ROLL REBIRTH CD New 0198000274771	166699580674	18.99
219	5IVE YEARS GONE ROCK ‘N’ ROLL REBIRTH CD New 0198000274771	166695964104	18.99
220	5IVE YEARS GONE ROCK ‘N’ ROLL REBIRTH CD New 0198000274771	145699232130	18.99
221	5TH SONIC BRIGADE 5TH SONIC BRIGADE CD New 0200000012236	166684515872	21.99
222	5TH SONIC BRIGADE 5TH SONIC BRIGADE CD New 0200000012236	166695980857	21.99
223	5TH SONIC BRIGADE 5TH SONIC BRIGADE CD New 0200000012236	145710008740	21.99
224	60 YEARS OF SCOTTISH GAELIC LE PATRIMOINE MUSICAL GAÉLIQUE ÉCOSSAIS 1899-1959 2C	166695971102	32.99
225	60 YEARS OF SCOTTISH GAELIC LE PATRIMOINE MUSICAL GAÉLIQUE ÉCOSSAIS 1899-1959 2C	145699217917	32.99
226	60 YEARS OF SCOTTISH GAELIC LE PATRIMOINE MUSICAL GAÉLIQUE ÉCOSSAIS 1899-1959 2C	145710017685	32.99
227	66CRUSHER LIMBO CD New 7090039726937	166684515832	21.99
228	66CRUSHER LIMBO CD New 7090039726937	145710024244	21.99
229	69 BEAVERSHOT MAXIMUM ROCKABILLY CD New 0820680716721	166699586279	15.99
230	69 BEAVERSHOT MAXIMUM ROCKABILLY CD New 0820680716721	166695980028	15.99
231	69 BEAVERSHOT MAXIMUM ROCKABILLY CD New 0820680716721	145699232093	15.99
232	69 CHAMBERS MACHINE CD New 4028466900142	166699589027	21.99
233	69 CHAMBERS MACHINE CD New 4028466900142	166684515831	21.99
234	69 CHAMBERS MACHINE CD New 4028466900142	145706907527	21.99
235	69 EYES DEVILS (2LP) 2LP New 4059251555537	166699598321	35.99
236	69 EYES DEVILS (2LP) 2LP New 4059251555537	145699217906	35.99
237	69 EYES PARIS KILLS LP New 4059251555544	166699598330	30.99
238	69 EYES PARIS KILLS LP New 4059251555544	166684505053	30.99
239	69 HARD BLUES FROM HELL CD New 7350007600035	166695983273	20.99
240	69 HARD BLUES FROM HELL CD New 7350007600035	145699232085	20.99
241	69 HARD BLUES FROM HELL CD New 7350007600035	145710024659	20.99
Find duplicates for tbleBayAllL

[/QUOTE]

 

[divster27]

HI @rlv01 - thanks again for your help.

I managed to get it to run the code - it didn't quite work as expected, but probably because i didn't explain it fully.

Sometimes there is 2 duplicates, sometimes 4 - it didnt seem to always work correctly then.

but managed to get about 95% of what i needed! thank you