Posts by pjums

  • Countifs

    Why the sensitivity around curly parenthesis, can something be done about it, fearing someone will break it

  • Countifs

    Have removed dates to avoid noise.


    Based on the pivot I should see 131 for incidents and prtg in B6, but its showing 0

  • Countifs

    Not that simple...


    All the range need to be dynamic!


    I should also be able to select more than one category on the slicer in column K

  • Countifs

    I think you can completely ignore the dates, they are not relevant. Remove them from the formula for the ease of it.

  • Countifs

    Here


    Look for the formula in B6 to B8


    I want to be able to select the ticket types from the slicer pivot in Row K and have my numbers returned accordingly


    Makes sense ?

    Files

    • For Carim.xlsx

      (44.46 kB, downloaded 33 times, last: )

  • Countifs

    What I am trying to acheive is more complex than what I have requested here... so sample file will confuse. Does my logic make some sense to attempt something without the sample file?

  • Countifs

    Thanks Carim, I think I know how to use countif and that's why believe my logic is not correct but cant figure out how to fix it....


    Perhaps I should rephrase my question and say :


    I need a logic to return the total count of rows from Raw Data table which match 2 criteria:

    1- column E contains Fix

    2- column F of Raw Data matches any entry present in Column A of the slicer table



    I don't care if its countif or anything else, so long as I can have a right output

  • Countifs

    No !! I am only just back at working on this project today... This issue takes priority now !


    a big HIIIIIIII btw, missed you :)

  • Countifs

    I am sure I am not oing it right but cant get my head around the right way!


    =(COUNTIFS('Raw Data'!E:E,"Fix",'Raw Data'!F:F.'Slicer'!A:A))


    I want the logic to return the count of rows from Raw Data table when column E contains Fix and column F of Raw Data matches any entry present in Column A of the slicer table


    Silcer table looks like this


    Row Labels
    Complex CR
    Incidents
    PRTG Alerts
    Requests
    RFI
    Simple CR

  • Remove all but first duplicate

    thank you ... my headers are in row 1.

  • Remove all but first duplicate

    You may not like me going to tangent but I need to priortise removing other response duplicates. I have re-written this. Its removing all the duplicates, but its also removing the headers of the table. WHat is wrong with this code ?


  • Remove all but first duplicate

    To put things back in their context ... you are testing the latest Sub RemoveDupsFixAdapted() macro, in order to only keep the Highest Priority ( which is by design the Smallest Number ...)

    - Yes.


    1. Do we agree that in your real life sheet ... descriptions similar to " Fix - Product Type 1 - P1" do show in Column O (after N & Before P)

    Yes, its in COlumn O


    2. Do we agree that in your real life sheet ... descriptions similar to " Fix - Product Type 1 - P1" always end up with the Priority Number

    I found there is one more category which doesnt end in a number. Fix - Desktop Support - Quick Assist. We may need to include it but for now the code to work I have suffixed it to make it look like "Fix - Desktop Support - Quick Assist - P4"



    3. Do we agree that in your real life sheet ... descriptions similar to " Fix - Product Type 1 - P1" do not have hidden spaces at the end ...

    No hidden spaces

  • Remove all but first duplicate

    Hi Carim


    Thank you for your paitence.


    rng.AutoFilter Field:=15, Criteria1:=">" & "*" & Evaluate("=SMALL(RIGHT(O" & a & ":O" & b & ",1)*1,1)")


    is returning error 13


    Only change I made to your code was replaced sheet1 with ActiveSheet