Hello, I need help In my attachment I have a table with Mobile Phone Attempts and the Results of Attempts : F(Failed), R(Rejected), S(Succesfull). I need to do something like that :
For example :
I filter Pivot table for F(Failed) and I need to qualify all Mobile Models, who has less attempts than 3 (<3) to the category Other with a sum of all Mobile Models with less attempts than 3.
mobilephones.xls
Example :
Failure table
Nokia 6300 ------- 1
Nokia 5300 -------- 2
Result
Category Other : 1+2
Maybe there is a way to do it in VBA ? Please help... Its damn complicated and hard, but I hope someone will help me with this.
Greetings, Adam
Bookmarks