Posts by pjums

• Countifs

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

WORKS!

Thanks a lot

• 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

they appear in a column that I have deleted !

• 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 7 times, last: )
• Countifs

Guilty as charged!

• 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

• Remove all but first duplicate

just have too much backlog because I was off sick- I am testing it now

• Remove all but first duplicate

i added the corresponding column in row 2 of the real life worksheet. Please read task Type as Ticket type which is column F.

Column J is Task.

• Remove all but first duplicate

Agree !

.AutoFilter Field:=8, Criteria1:="Duplicate" returns 1004 error

• Remove all but first duplicate

I may need your address to send a token of recognition :X