Creating a table to help remove duplicates

divster27

divster27

New Member
Joined
Jan 19, 2021
Messages
32
Office Version
  1. 2016
Platform
  1. Windows
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
 

Attachments

  • 2024-04-21_17-03-38.png
    2024-04-21_17-03-38.png
    204.5 KB · Views: 22

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Why not just use the "Remove Duplicates" feature under the "Data" menu?

FWIW, when you post an image of your data instead of something that can be copied and pasted into a spreadsheet, it is difficult for others to experiment with it. Which means your chances of getting help drop significantly. Instead, use the free XL2BB tool to post your data in a way that makes it accessible to others.

www.mrexcel.com

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...
www.mrexcel.com www.mrexcel.com
 
Upvote 0
thank you - but i need to keep the dupliactes, so that i can upload them somewhere else.

Find duplicates for tbleBayAllListings.xlsx
ABC
1TitleItem numberCurrent price
2(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301116668450506846.99
3(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114571003243546.99
4(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114570692683646.99
5(DOLCH) NACHT CD New 425093653300416669959017726.99
6(DOLCH) NACHT CD New 425093653300416669596300626.99
7(DOLCH) NACHT CD New 425093653300414569923207126.99
8(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916669958037418.99
9(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916668436774918.99
10(HED) P.E. TRUTH RISING CD New 067395102132714569923209818.99
11(HED) P.E. TRUTH RISING CD New 067395102132714570689297718.99
12(HED) P.E. TRUTH RISING CD New 067395102132714571000976318.99
13(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16669958851423.99
14(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16668451583723.99
15(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA14570690663623.99
16(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616669959469519.99
17(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616668450626419.99
18(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187614570693095419.99
191/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576616668451561815.99
201/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614570689710415.99
211/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614571002357715.99
221/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716669959962224.99
231/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716668450503724.99
241/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576714570692593024.99
2510,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 081951401141516669958626117.99
2610,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 081951401141516668451585217.99
2710,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 081951401141516669597294917.99
2810,000 MANIACS IN THE CITY OF ANGELS CD New 082356467162816669597583813.99
2910,000 MANIACS IN THE CITY OF ANGELS CD New 082356467162814569923211413.99
3010,000 MANIACS IN THE CITY OF ANGELS CD New 082356467162814571001522713.99
3110,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 529231780461616669959185320.99
3210,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 529231780461616668451585820.99
3310,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 529231780461614570691026920.99
34100 MILE HOUSE HIRAETH LP New 084273600101816669599787932.99
35100 MILE HOUSE HIRAETH LP New 084273600101816669959725632.99
36100 MILE HOUSE HIRAETH LP New 084273600101814569922102232.99
37100 MILE HOUSE LOVE AND LEAVE YOU LP New 084273600151314569922101927.99
38100 MILE HOUSE LOVE AND LEAVE YOU LP New 084273600151314571003081827.99
39100 MILE HOUSE LOVE AND LEAVE YOU LP New 084273600151314570693012127.99
40107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 071047318423616669958323119.99
41107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 071047318423616669596447119.99
42107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 071047318423616668451585319.99
431349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 707280500220916669959968134.99
441349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 707280500220916669599736634.99
451349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 707280500220916668450010434.99
461349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 70728016669599735134.99
471349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 70728014569922102834.99
481349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 70728014571003395134.99
491349 RYKKINN BROWN RING OF FURY CD New 703553888327916669959275920.99
501349 RYKKINN BROWN RING OF FURY CD New 703553888327916669596842420.99
511349 RYKKINN BROWN RING OF FURY CD New 703553888327914569923211320.99
521349 SLAVES 7 New 709001438920114569922188719.99
531349 SLAVES 7 New 709001438920114571003416419.99
541349 SLAVES 7 New 709001438920114570693337719.99
5513TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 080334155372916669959658028.99
5613TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 080334155372916669599126828.99
5713TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 080334155372916668450011328.99
581476 IN EXILE CD New 088438886876216669958774920.99
591476 IN EXILE CD New 088438886876216668451584920.99
6016 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 074586073799316668450504529.99
6116 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 074586073799314571002913029.99
6216 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 074586073799314570692904929.99
6316 / GRIME DOOM SESSIONS VOL. 3 CD New 074586073797916668451585418.99
6416 / GRIME DOOM SESSIONS VOL. 3 CD New 074586073797914570690092818.99
6516 / GRIME DOOM SESSIONS VOL. 3 CD New 074586073797914571001076218.99
6616 / GRIME DOOM SESSIONS VOL. 3 LP New 074586073798616669959611724.99
6716 / GRIME DOOM SESSIONS VOL. 3 LP New 074586073798616669599588324.99
6816 / GRIME DOOM SESSIONS VOL. 3 LP New 074586073798614569922103224.99
6917 CRASH STAMINA CD New 805112862208916669959412424.99
7017 CRASH STAMINA CD New 805112862208916669596153624.99
7117 CRASH STAMINA CD New 805112862208914569923210924.99
721782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 074586073748116669596680418.99
731782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 074586073748114569923209218.99
741782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 074586073748114571001075718.99
751782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 061037180486414569922102529.99
761782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 061037180486414571002729129.99
771782 CLAMOR LUCIFERI CD New 061037180484014569923211218.99
781782 CLAMOR LUCIFERI CD New 061037180484014571000903818.99
791782 CLAMOR LUCIFERI LP New 061037180485716669959519624.99
801782 CLAMOR LUCIFERI LP New 061037180485714569922101724.99
811782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 064769734072116669959551729.99
821782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 064769734072116669599574829.99
831782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 064769734072116668450504829.99
841782 FROM THE GRAVEYARD CD New 064769734070716669958228018.99
851782 FROM THE GRAVEYARD CD New 064769734070716669596570318.99
861782 FROM THE GRAVEYARD CD New 064769734070714569923210818.99
871782 FROM THE GRAVEYARD LP New 064769734071416668450504624.99
881782 FROM THE GRAVEYARD LP New 064769734071414571002786324.99
891782 FROM THE GRAVEYARD LP New 064769734071414570692891824.99
9021OCTAYNE 2.0 (LIMITED DIGI) CD New 088486013782916668451583315.99
9121OCTAYNE 2.0 (LIMITED DIGI) CD New 088486013782916669597625115.99
9221OCTAYNE 2.0 (LIMITED DIGI) CD New 088486013782914571001665915.99
9321OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 088486010092216668451583615.99
9421OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 088486010092214570691292615.99
9521OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 088486010092214571001663715.99
9622 YOU ARE CREATING (2CD) 2CD New 088692287642416669958829824.99
9722 YOU ARE CREATING (2CD) 2CD New 088692287642416669597050324.99
9822 YOU ARE CREATING (2CD) 2CD New 088692287642414569921790124.99
9922 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 709001438359914571003415532.99
10022 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 709001438359916668450029332.99
10122 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 709001438359914570693144032.99
10222 YOU ARE CREATING 2CD New 709001438360516669597050822.99
10322 YOU ARE CREATING 2CD New 709001438360516668450029722.99
10422 YOU ARE CREATING 2CD New 709001438360514571002396722.99
10522 YOU ARE CREATING: LIMB1 (CLEAR W/GREEN SPOTS VINYL) LP New 709001439319216669599984932.99
10622 YOU ARE CREATING: LIMB1 (CLEAR W/GREEN SPOTS VINYL) LP New 709001439319216668450505232.99
10722 YOU ARE CREATING: LIMB1 (CLEAR W/GREEN SPOTS VINYL) LP New 709001439319214571003418532.99
10823 ACEZ REDEMPTION WAVES CD New 570090726186716669959204618.99
10923 ACEZ REDEMPTION WAVES CD New 570090726186716668451585018.99
11023 ACEZ REDEMPTION WAVES CD New 570090726186716669597709918.99
11124 HEURES AVEC LES LOUPS THE WOLVES CD New 356130210102614569923209923.99
11224 HEURES AVEC LES LOUPS THE WOLVES CD New 356130210102614571001761723.99
11324 PESOS BUSTED BROKEN AND BLUE CD New 506013995083116668451584520.99
11424 PESOS BUSTED BROKEN AND BLUE CD New 506013995083116669597866620.99
11524 PESOS BUSTED BROKEN AND BLUE CD New 506013995083114571002145920.99
11624 PESOS WHEN THE SHIP GOES DOWN CD New 506013995096116669597867020.99
11724 PESOS WHEN THE SHIP GOES DOWN CD New 506013995096114569923211520.99
11824 PESOS WHEN THE SHIP GOES DOWN CD New 506013995096114571002147420.99
11924PESOS DO THE RIGHT THING CD New 880015588065416669959440720.99
12024PESOS DO THE RIGHT THING CD New 880015588065416668451584820.99
12124PESOS DO THE RIGHT THING CD New 880015588065414570691238220.99
1222ND FACE UTOPIUM CD New 088438887407714569923210720.99
1232ND FACE UTOPIUM CD New 088438887407714571001650720.99
1242PAC RAP & REVOLUTION - INSTRUMENTALS 2LP New 843602262493116669600037824.99
1252PAC RAP & REVOLUTION - INSTRUMENTALS 2LP New 843602262493116669960028024.99
1262PAC RAP & REVOLUTION - INSTRUMENTALS 2LP New 843602262493114569921775524.99
1272RAUMWOHNUNG 20JAHRE 2RAUMWOHNUNG CD New 425062460127516669959013420.99
1282RAUMWOHNUNG 20JAHRE 2RAUMWOHNUNG CD New 425062460127514570690303620.99
1292RAUMWOHNUNG 20JAHRE 2RAUMWOHNUNG CD New 425062460127514569923210620.99
1302RAUMWOHNUNG ACHTUNG FERTIG (EXPANDED EDITION) CD New 425062460052016669597271518.99
1312RAUMWOHNUNG ACHTUNG FERTIG (EXPANDED EDITION) CD New 425062460052014569923211018.99
1322RAUMWOHNUNG ACHTUNG FERTIG (EXPANDED EDITION) CD New 425062460052014571001966818.99
1332RAUMWOHNUNG LASSO CD New 425062460013116669959013818.99
1342RAUMWOHNUNG LASSO CD New 425062460013116668451584718.99
1352RAUMWOHNUNG LASSO CD New 425062460013116669597272618.99
1362RAUMWOHNUNG MELANCHOLISCH SCHÖN CD New 425062460008714569923210518.99
1372RAUMWOHNUNG MELANCHOLISCH SCHÖN CD New 425062460008714570690827518.99
1382RAUMWOHNUNG MELANCHOLISCH SCHÖN CD New 425062460008714571001966418.99
1393 INCHES OF BLOOD HERE WAITS THY DOOM 2LP New 019411102350514569921772032.99
1403 INCHES OF BLOOD HERE WAITS THY DOOM 2LP New 019411102350514571002688332.99
1413 INCHES OF BLOOD LONG LIVE HEAVY METAL 2LP New 019411102351216669959490432.99
1423 INCHES OF BLOOD LONG LIVE HEAVY METAL 2LP New 019411102351214569921771132.99
1433 SOUNDS, THE HERE WE COME LP New 370047783477716669959777927.99
1443 SOUNDS, THE HERE WE COME LP New 370047783477716668450502627.99
1453 SOUNDS, THE HERE WE COME LP New 370047783477714570692483427.99
1463 SOUNDS, THE INTRODUCING THE 3 SOUNDS LP New 370047783585914569922102427.99
1473 SOUNDS, THE INTRODUCING THE 3 SOUNDS LP New 370047783585914571003152827.99
14835 TAPES FABRIC OF TIME CD New 709003972739216668451584623.99
14935 TAPES FABRIC OF TIME CD New 709003972739214571002425723.99
15035 TAPES FABRIC OF TIME LP New 709003972740816669959998540.99
15135 TAPES FABRIC OF TIME LP New 709003972740814569922102140.99
15235 TAPES HOME CD New 709003972398116669596586720.99
15335 TAPES HOME CD New 709003972398114569923210020.99
15435 TAPES HOME CD New 709003972398114571002418120.99
15535 TAPES HOME LP New 709003972399814569922100732.99
15635 TAPES HOME LP New 709003972399814571003433232.99
15735 TAPES HOME LP New 709003972399814570692890032.99
15836? MILK MOUNTAIN LP New 072475291578716669599795424.99
15936? MILK MOUNTAIN LP New 072475291578716668450502524.99
16036? MILK MOUNTAIN LP New 072475291578714571002894624.99
16137 STABWOUNDS A HEART GONE BLACK CD New 871539290452316669959431613.99
16237 STABWOUNDS A HEART GONE BLACK CD New 871539290452316668451584313.99
16337 STABWOUNDS A HEART GONE BLACK CD New 871539290452316669598059613.99
1643RD & THE MORTAL, THE 2 EP'S (WHITE VINYL) LP New 707280500645016669959970434.99
1653RD & THE MORTAL, THE 2 EP'S (WHITE VINYL) LP New 707280500645014569922101634.99
1663RD & THE MORTAL, THE 2 EP'S (WHITE VINYL) LP New 707280500645014570692927634.99
1673RD & THE MORTAL, THE 2 EP'S LP New 707280500605414569922101132.99
1683RD & THE MORTAL, THE 2 EP'S LP New 707280500605414571003395732.99
1693RD & THE MORTAL, THE 2 EP'S LP New 707280500605414570692926832.99
1703RD & THE MORTAL, THE EP’S & RARITIES CD New 707280500760016669959284521.99
1713RD & THE MORTAL, THE EP’S & RARITIES CD New 707280500760016668451586221.99
1723RD & THE MORTAL, THE EP’S & RARITIES CD New 707280500760014570689955821.99
1733RD & THE MORTAL, THE MEMOIRS (BROWN VINYL) 2LP New 707280500644316668450013843.99
1743RD & THE MORTAL, THE MEMOIRS (BROWN VINYL) 2LP New 707280500644314571003396143.99
1753RD & THE MORTAL, THE MEMOIRS (BROWN VINYL) 2LP New 707280500644314570692930343.99
1763RD & THE MORTAL, THE MEMOIRS 2LP New 707280500604716669599614840.99
1773RD & THE MORTAL, THE MEMOIRS 2LP New 707280500604716668450012340.99
1783RD & THE MORTAL, THE MEMOIRS 2LP New 707280500604714571003396740.99
1793RD & THE MORTAL, THE MEMOIRS CD New 707280500759414569923210321.99
1803RD & THE MORTAL, THE MEMOIRS CD New 707280500759414570689956021.99
1813RD & THE MORTAL, THE MEMOIRS CD New 707280500759414571002375921.99
1823RD & THE MORTAL, THE TEARS LAID IN EARTH CD New 707280500758716669959284721.99
1833RD & THE MORTAL, THE TEARS LAID IN EARTH CD New 707280500758716669596454421.99
1843RD & THE MORTAL, THE TEARS LAID IN EARTH CD New 707280500758714569923210421.99
1853RD ATTEMPT, THE BORN IN THORNS CD New 709000831095216668451586912.99
1863RD ATTEMPT, THE BORN IN THORNS CD New 709000831095214571002382412.99
1873RD ATTEMPT, THE EGOCIDAL PATH CD New 709000831135514569923212912.99
1883RD ATTEMPT, THE EGOCIDAL PATH CD New 709000831135514570690834812.99
1893RD ATTEMPT, THE EGOCIDAL PATH CD New 709000831135514571002384512.99
1903RD ATTEMPT, THE EGOCIDAL PATH LP New 709000831902316669959981716.99
1913RD ATTEMPT, THE EGOCIDAL PATH LP New 709000831902316668450503316.99
1923RD ATTEMPT, THE EGOCIDAL PATH LP New 709000831902314570693207316.99
193400 LONELY THINGS MOTHER MOON CD New 064187174609516669958216518.99
194400 LONELY THINGS MOTHER MOON CD New 064187174609516668451586718.99
19542 DECIBEL ROLLING IN TOWN (LP+CD) LP New 088692269171314569922101324.99
19642 DECIBEL ROLLING IN TOWN (LP+CD) LP New 088692269171314571003136224.99
19742 DECIBEL ROLLING IN TOWN CD New 088692269172016668451586615.99
19842 DECIBEL ROLLING IN TOWN CD New 088692269172014571001709815.99
199430 STEPS CITIZEN OF NOTHING LP New 076013737261516669599684732.99
200430 STEPS CITIZEN OF NOTHING LP New 076013737261514569922101532.99
201430 STEPS CITIZEN OF NOTHING LP New 076013737261514571002932332.99
20245 ADAPTERS COLLECTED WORKS (NEON ORANGE VINYL) D10 New 087919800957316668450597527.99
20345 ADAPTERS COLLECTED WORKS (NEON ORANGE VINYL) D10 New 087919800957314571003104027.99
20445 ADAPTERS COLLECTED WORKS (NEON ORANGE VINYL) D10 New 087919800957314570692861427.99
20545 ADAPTERS NOW OR NEVER (DIGITALLY PRINTED 12 INCH) 12 New 081001764528214569922162524.99
20645 ADAPTERS NOW OR NEVER (DIGITALLY PRINTED 12 INCH) 12 New 081001764528214571003014824.99
20745 ADAPTERS NOW OR NEVER (DIGITALLY PRINTED 12 INCH) 12 New 081001764528214570692912924.99
20845 ADAPTERS THEY CALL IT JUSTICE 7 New 081486702335116668450626715.99
20945 ADAPTERS THEY CALL IT JUSTICE 7 New 081486702335114571003032115.99
2105 ROYALES Its Hard But Its Fair CD New 002966700612516669957911318.99
2115 ROYALES Its Hard But Its Fair CD New 002966700612516669598298618.99
2125 SECONDS OF SUMMER X-POSED CD New 08235647090241666995869738.99
2135 SECONDS OF SUMMER X-POSED CD New 08235647090241666845158688.99
2145 SECONDS OF SUMMER X-POSED CD New 08235647090241666959776698.99
21550 CENT I'M STILL RUNNING THIS CD New 506033057111814569923213115.99
21650 CENT I'M STILL RUNNING THIS CD New 506033057111814570691235515.99
21750 CENT I'M STILL RUNNING THIS CD New 506033057111814571002155315.99
2185IVE YEARS GONE ROCK ‘N’ ROLL REBIRTH CD New 019800027477116669958067418.99
2195IVE YEARS GONE ROCK ‘N’ ROLL REBIRTH CD New 019800027477116669596410418.99
2205IVE YEARS GONE ROCK ‘N’ ROLL REBIRTH CD New 019800027477114569923213018.99
2215TH SONIC BRIGADE 5TH SONIC BRIGADE CD New 020000001223616668451587221.99
2225TH SONIC BRIGADE 5TH SONIC BRIGADE CD New 020000001223616669598085721.99
2235TH SONIC BRIGADE 5TH SONIC BRIGADE CD New 020000001223614571000874021.99
22460 YEARS OF SCOTTISH GAELIC LE PATRIMOINE MUSICAL GAÉLIQUE ÉCOSSAIS 1899-1959 2C16669597110232.99
22560 YEARS OF SCOTTISH GAELIC LE PATRIMOINE MUSICAL GAÉLIQUE ÉCOSSAIS 1899-1959 2C14569921791732.99
22660 YEARS OF SCOTTISH GAELIC LE PATRIMOINE MUSICAL GAÉLIQUE ÉCOSSAIS 1899-1959 2C14571001768532.99
22766CRUSHER LIMBO CD New 709003972693716668451583221.99
22866CRUSHER LIMBO CD New 709003972693714571002424421.99
22969 BEAVERSHOT MAXIMUM ROCKABILLY CD New 082068071672116669958627915.99
23069 BEAVERSHOT MAXIMUM ROCKABILLY CD New 082068071672116669598002815.99
23169 BEAVERSHOT MAXIMUM ROCKABILLY CD New 082068071672114569923209315.99
23269 CHAMBERS MACHINE CD New 402846690014216669958902721.99
23369 CHAMBERS MACHINE CD New 402846690014216668451583121.99
23469 CHAMBERS MACHINE CD New 402846690014214570690752721.99
23569 EYES DEVILS (2LP) 2LP New 405925155553716669959832135.99
23669 EYES DEVILS (2LP) 2LP New 405925155553714569921790635.99
23769 EYES PARIS KILLS LP New 405925155554416669959833030.99
23869 EYES PARIS KILLS LP New 405925155554416668450505330.99
23969 HARD BLUES FROM HELL CD New 735000760003516669598327320.99
24069 HARD BLUES FROM HELL CD New 735000760003514569923208520.99
24169 HARD BLUES FROM HELL CD New 735000760003514571002465920.99
Find duplicates for tbleBayAllL
 
Upvote 0
Maybe something like this.

VBA Code: 
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
 
Upvote 0
Possible formula solution?
Autofilter Demo.xlsm
ABCD
1TitleItem numberCurrent price
2(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301116668450506846.99End
3(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114571003243546.99End
4(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114570692683645.99 
5(DOLCH) NACHT CD New 425093653300416669959017726.99End
6(DOLCH) NACHT CD New 425093653300416669596300626.99End
7(DOLCH) NACHT CD New 425093653300414569923207126.99 
8(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916669958037418.99End
9(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916668436774918.99 
10(HED) P.E. TRUTH RISING CD New 067395102132714569923209818.99 
11(HED) P.E. TRUTH RISING CD New 067395102132714570689297718.99End
12(HED) P.E. TRUTH RISING CD New 067395102132714571000976318.99End
13(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16669958851423.99End
14(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16668451583723.99End
15(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA14570690663623.99 
16(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616669959469519.99End
17(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616668450626419.99End
18(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187614570693095419.99 
191/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576616668451561815.99End
201/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614570689710415.99 
211/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614571002357715.99End
221/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716669959962224.99End
231/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716668450503724.99End
241/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576714570692593024.99 
Sheet2
Cell Formulas
RangeFormula
D2:D24D2=IF(AND(COUNTIF(A:A,A2)>1,OR(MIN(IF(A:A=A2,B:B))<>B2,MIN(IF(A:A=A2,C:C))<>C2)),"End","")
Named Ranges
NameRefers ToCells
_FilterDatabase=Sheet2!$A$1:$D$241D2:D24
 
Upvote 0
kevin9999 said:
Possible formula solution?
Autofilter Demo.xlsm
ABCD
1TitleItem numberCurrent price
2(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301116668450506846.99End
3(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114571003243546.99End
4(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114570692683645.99 
5(DOLCH) NACHT CD New 425093653300416669959017726.99End
6(DOLCH) NACHT CD New 425093653300416669596300626.99End
7(DOLCH) NACHT CD New 425093653300414569923207126.99 
8(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916669958037418.99End
9(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916668436774918.99 
10(HED) P.E. TRUTH RISING CD New 067395102132714569923209818.99 
11(HED) P.E. TRUTH RISING CD New 067395102132714570689297718.99End
12(HED) P.E. TRUTH RISING CD New 067395102132714571000976318.99End
13(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16669958851423.99End
14(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16668451583723.99End
15(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA14570690663623.99 
16(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616669959469519.99End
17(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616668450626419.99End
18(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187614570693095419.99 
191/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576616668451561815.99End
201/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614570689710415.99 
211/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614571002357715.99End
221/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716669959962224.99End
231/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716668450503724.99End
241/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576714570692593024.99 
Sheet2
Cell Formulas
RangeFormula
D2:D24D2=IF(AND(COUNTIF(A:A,A2)>1,OR(MIN(IF(A:A=A2,B:B))<>B2,MIN(IF(A:A=A2,C:C))<>C2)),"End","")
Named Ranges
NameRefers ToCells
_FilterDatabase=Sheet2!$A$1:$D$241D2:D24
Click to expand...
thanks for this - i'm not sure if it worked, as i changed the price on one of them (the bottom triplet) and the formula seems to add END to each of them..?

Book1
ABCD
1TitleItem numberCurrent price
2(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301116668450506846.99End
3(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114571003243546.99End
4(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114570692683645.99 
5(DOLCH) NACHT CD New 425093653300416669959017726.99End
6(DOLCH) NACHT CD New 425093653300416669596300626.99End
7(DOLCH) NACHT CD New 425093653300414569923207126.99 
8(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916669958037418.99End
9(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916668436774918.99 
10(HED) P.E. TRUTH RISING CD New 067395102132714569923209818.99 
11(HED) P.E. TRUTH RISING CD New 067395102132714570689297718.99End
12(HED) P.E. TRUTH RISING CD New 067395102132714571000976318.99End
13(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16669958851423.99End
14(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16668451583723.99End
15(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA14570690663623.99 
16(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616669959469519.99End
17(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616668450626419.99End
18(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187614570693095419.99 
191/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576616668451561815.99End
201/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614570689710415.99 
211/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614571002357715.99End
221/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716669959962224.99End
231/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716668450503722.99End
241/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576714570692593024.99End
Sheet1
Cell Formulas
RangeFormula
D2:D24D2=IF(AND(COUNTIF(A:A,A2)>1,OR(MIN(IF(A:A=A2,B:B))<>B2,MIN(IF(A:A=A2,C:C))<>C2)),"End","")
 
Upvote 0
rlv01 said:
Maybe something like this.

VBA Code: 
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
Click to expand...

Apologies - i'm not entirely sure what to do with this code - very much a low level Excel user!
 
Upvote 0
Sorry, the OR should have been an AND.

Rich (BB code): 
=IF(AND(COUNTIF(A:A,A2)>1,AND(MIN(IF(A:A=A2,B:B))<>B2,MIN(IF(A:A=A2,C:C))<>C2)),"End","")
 
Upvote 0
two different results: base on smallest ID or last smallest value

Book1
ABCDE
1TitleItem numberCurrent priceBase on last min value in CBase on smallest ID in B
2(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301116668450506846.99EndEnd
3(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114571003243546.99EndEnd
4(DOLCH) NACHT (SKY BLUE VINYL) LP New 425093653301114570692683646.99  
5(DOLCH) NACHT CD New 425093653300416669959017726.99EndEnd
6(DOLCH) NACHT CD New 425093653300416669596300626.99EndEnd
7(DOLCH) NACHT CD New 425093653300414569923207126.99  
8(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916669958037418.99EndEnd
9(HED) P.E. & DROPOUT KINGS LAST ONES STANDING CD New 019264182134916668436774918.99  
10(HED) P.E. TRUTH RISING CD New 067395102132714569923209818.99End 
11(HED) P.E. TRUTH RISING CD New 067395102132714570689297718.99EndEnd
12(HED) P.E. TRUTH RISING CD New 067395102132714571000976318.99 End
13(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16669958851423.99EndEnd
14(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA16668451583723.99EndEnd
15(LES GRANDS VIRTUOSES N°2 / THE GREAT MASTERS N°2) LES PLUS BEAUX CHANTS D’OISEA14570690663623.99  
16(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616669959469519.99EndEnd
17(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187616668450626419.99EndEnd
18(MISS) JACKIE MOORE WHO TOLD YOU 7 New 002966702187614570693095419.99  
191/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576616668451561815.99EndEnd
201/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614570689710415.99End 
211/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL CD New 701966272576614571002357715.99 End
221/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716669959962224.99EndEnd
231/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576716668450503724.99EndEnd
241/2 SOUTHERN NORTH NARRATIONS OF A FALLEN SOUL LP New 701977772576714570692593024.99  
2510,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 081951401141516669958626117.99EndEnd
2610,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 081951401141516668451585217.99End 
2710,000 MANIACS HALLOWEEN LIVE AT DISNEY INSTITUTE CD New 081951401141516669597294917.99 End
2810,000 MANIACS IN THE CITY OF ANGELS CD New 082356467162816669597583813.99EndEnd
2910,000 MANIACS IN THE CITY OF ANGELS CD New 082356467162814569923211413.99End 
3010,000 MANIACS IN THE CITY OF ANGELS CD New 082356467162814571001522713.99 End
3110,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 529231780461616669959185320.99EndEnd
3210,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 529231780461616668451585820.99EndEnd
3310,000 MANIACS LIVE AT THE RITZ, NY, 7TH AUG '87 CD New 529231780461614570691026920.99  
34100 MILE HOUSE HIRAETH LP New 084273600101816669599787932.99EndEnd
35100 MILE HOUSE HIRAETH LP New 084273600101816669959725632.99EndEnd
36100 MILE HOUSE HIRAETH LP New 084273600101814569922102232.99  
37100 MILE HOUSE LOVE AND LEAVE YOU LP New 084273600151314569922101927.99End 
38100 MILE HOUSE LOVE AND LEAVE YOU LP New 084273600151314571003081827.99EndEnd
39100 MILE HOUSE LOVE AND LEAVE YOU LP New 084273600151314570693012127.99 End
40107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 071047318423616669958323119.99EndEnd
41107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 071047318423616669596447119.99EndEnd
42107TH STREET STICKBALL TEAM SABOREANDO, POT FULL OF SOUL CD New 071047318423616668451585319.99  
431349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 707280500220916669959968134.99EndEnd
441349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 707280500220916669599736634.99EndEnd
451349 DEMONOIR (SPECIAL EDITION GOLD VINYL) 2LP New 707280500220916668450010434.99  
461349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 70728016669599735134.99EndEnd
471349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 70728014569922102834.99End 
481349 MASSIVE CAULDRON OF CHAOS (SPECIAL EDITION BLACK/WHITE VINYL) LP New 70728014571003395134.99 End
491349 RYKKINN BROWN RING OF FURY CD New 703553888327916669959275920.99EndEnd
501349 RYKKINN BROWN RING OF FURY CD New 703553888327916669596842420.99EndEnd
511349 RYKKINN BROWN RING OF FURY CD New 703553888327914569923211320.99  
521349 SLAVES 7 New 709001438920114569922188719.99End 
531349 SLAVES 7 New 709001438920114571003416419.99EndEnd
541349 SLAVES 7 New 709001438920114570693337719.99 End
5513TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 080334155372916669959658028.99EndEnd
5613TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 080334155372916669599126828.99EndEnd
5713TH FLOOR ELEVATORS THE REUNION CONCERT (2LP) 2LP New 080334155372916668450011328.99  
581476 IN EXILE CD New 088438886876216669958774920.99EndEnd
591476 IN EXILE CD New 088438886876216668451584920.99  
6016 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 074586073799316668450504529.99EndEnd
6116 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 074586073799314571002913029.99EndEnd
6216 / GRIME DOOM SESSIONS VOL. 3 (COLOURED VINYL) LP New 074586073799314570692904929.99  
6316 / GRIME DOOM SESSIONS VOL. 3 CD New 074586073797916668451585418.99EndEnd
6416 / GRIME DOOM SESSIONS VOL. 3 CD New 074586073797914570690092818.99End 
6516 / GRIME DOOM SESSIONS VOL. 3 CD New 074586073797914571001076218.99 End
6616 / GRIME DOOM SESSIONS VOL. 3 LP New 074586073798616669959611724.99EndEnd
6716 / GRIME DOOM SESSIONS VOL. 3 LP New 074586073798616669599588324.99EndEnd
6816 / GRIME DOOM SESSIONS VOL. 3 LP New 074586073798614569922103224.99  
6917 CRASH STAMINA CD New 805112862208916669959412424.99EndEnd
7017 CRASH STAMINA CD New 805112862208916669596153624.99EndEnd
7117 CRASH STAMINA CD New 805112862208914569923210924.99  
721782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 074586073748116669596680418.99EndEnd
731782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 074586073748114569923209218.99End 
741782 / ACID MAMMOTH DOOM SESSIONS - VOL. 2 CD New 074586073748114571001075718.99 End
751782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 061037180486414569922102529.99End 
761782 CLAMOR LUCIFERI (TRANSPARENT PURPLE VINYL) LP New 061037180486414571002729129.99 End
771782 CLAMOR LUCIFERI CD New 061037180484014569923211218.99End 
781782 CLAMOR LUCIFERI CD New 061037180484014571000903818.99 End
791782 CLAMOR LUCIFERI LP New 061037180485716669959519624.99EndEnd
801782 CLAMOR LUCIFERI LP New 061037180485714569922101724.99  
811782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 064769734072116669959551729.99EndEnd
821782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 064769734072116669599574829.99EndEnd
831782 FROM THE GRAVEYARD (COLOURED VINYL) LP New 064769734072116668450504829.99  
841782 FROM THE GRAVEYARD CD New 064769734070716669958228018.99EndEnd
851782 FROM THE GRAVEYARD CD New 064769734070716669596570318.99EndEnd
861782 FROM THE GRAVEYARD CD New 064769734070714569923210818.99  
871782 FROM THE GRAVEYARD LP New 064769734071416668450504624.99EndEnd
881782 FROM THE GRAVEYARD LP New 064769734071414571002786324.99EndEnd
891782 FROM THE GRAVEYARD LP New 064769734071414570692891824.99  
9021OCTAYNE 2.0 (LIMITED DIGI) CD New 088486013782916668451583315.99EndEnd
9121OCTAYNE 2.0 (LIMITED DIGI) CD New 088486013782916669597625115.99EndEnd
9221OCTAYNE 2.0 (LIMITED DIGI) CD New 088486013782914571001665915.99  
9321OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 088486010092216668451583615.99EndEnd
9421OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 088486010092214570691292615.99End 
9521OCTAYNE INTO THE OPEN (LIMITED DIGIPACK) CD New 088486010092214571001663715.99 End
9622 YOU ARE CREATING (2CD) 2CD New 088692287642416669958829824.99EndEnd
9722 YOU ARE CREATING (2CD) 2CD New 088692287642416669597050324.99EndEnd
9822 YOU ARE CREATING (2CD) 2CD New 088692287642414569921790124.99  
9922 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 709001438359914571003415532.99EndEnd
10022 YOU ARE CREATING (MINT + PURPLE VINYL) 2LP New 709001438359916668450029332.99EndEnd
Sheet1
Cell Formulas
RangeFormula
D2:D100D2=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:E100E2=IF(AGGREGATE(15,6,$B$2:$B$241/($A$2:$A$241=A2),1)=B2,"","End")
 
Upvote 0
thanks to both
kevin9999 said:
Sorry, the OR should have been an AND.

Rich (BB code): 
=IF(AND(COUNTIF(A:A,A2)>1,AND(MIN(IF(A:A=A2,B:B))<>B2,MIN(IF(A:A=A2,C:C))<>C2)),"End","")
Click to expand...
Thanks again - really appreciated

That only works if there is a price difference - if there's no price difference, it returns three blanks

the logical rule is, "from the duplicates, pick the lowest value OR if they're all the same value, pick the lowest Item number"
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
CountIFS and Sumif based on duplicate value in other columns
Replies
3
Views
295
jennybell
J
A
  • Question Question
Excel Function to Extract Text String, Remove Duplicate & Count
Replies
5
Views
280
arijitirf
A
M
  • Solved
Sum only the unique values from one column within a range of duplicate values from another column
Replies
7
Views
238
MARZIOTULLIO
M
A
  • Solved
Remove Duplicates - first instance
Replies
8
Views
953
JoeMo
J
T
  • Solved
take a column of daily transaction numbers with duplicates and show in different table with its corresponding date and no duplicates
2
Replies
13
Views
526
Dave Patton
D

Forum statistics

Threads
1,223,909
Messages
6,175,315
Members
452,634
Latest member
cpostell

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top