Remove all but first duplicate

  • I googled it and replaced it. It removed the headers. :(

    I do not know what you are exactly talking about ...

    SpecialCells itself ... does not interfere with the Range size ...


    You have to make sure your Range is properly defined ...

    Should you need assistance ... feel free to post your macro ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Regarding the macro to deal with all Duplicates with SLA type equal to Fix ...



    Let me know what is the outcome of your tests ...


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Hello,


    Once you have tested the ' second block ' macro ... feel free to share your comments ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Rather surprised not to get any feedback .... =O

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • The right order of Priorities:


    1. Hope YOU are doing well :)

    and then

    2. Hope the macro will operate as expected ... ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • You are welcome ...


    Yes E ... in this intruction is for Column E ...where SLA is listed and where .... starting from the Right ... you can extract the Priority Number ... such as in Fix - Product Type 1 - P1 to get the Number 1 ...


    Hope this clarifies

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Well ... do not know the exact structure of your actual file ...


    But ... wherever is located the SLA column which holds the Priority Numbers ... it is the Column Letter to use in replacement of Letter E


    Another possibility ... is for you ... to attach a file ONLY with your Headers in the first row .... and no data ...;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Thanks for the Headers file ... AND the respective Column Letters of your Original Test file ...:)


    Will review the macro accordingly ... ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • No hair left on my head ...!!! :S


    Hopefully ... following modifications should be in line with your actual structure ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • does criteria have to be a exact match ?

    On the response dups it would be wonderful to have something more mature like:


    .AutoFilter Field:=8

    .AutoFilter Field:=5

    .AutoFilter Field:=6, Criteria1:="PRTG Alerts"

    .AutoFilter Field:=15, Criteria1:= <<Doesnt contain Assignment>> Operator:=xlAnd, Criteria2:= <<Contains First>>


    as opposed to more static:

    .AutoFilter Field:=8

    .AutoFilter Field:=5

    .AutoFilter Field:=6, Criteria1:=">" & "PRTG Alerts"

    .AutoFilter Field:=15, Criteria1:="Incident First Assignment" Operator:=xlOr, Criteria2:="<=1000"

  • Pooja,


    Before getting back to refining the First Block designed for Response Dups ...


    would suggest to get the Second Block designed for Fix Dups out of the way ...


    Do you agree ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • By the way ... regarding your real life worksheet .... is the Task Type located in Column J or in Column P ...???


    The Column where you are getting PRTG, SQL, etc ....

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!