Count words in column and include county creteria and Request Type

Hi I have below working great jindon code. It count the words for the sub catagory in sheet 3 and put the result in sheet2 after country.
It works great, but i need it to be extended with one more creteria. Request type.

In below sheet you can see what i want. In sheet 3 you have the file. And in Sheet 2 you have hów it looks now. And in Sheet "Wanted layout", you can see how i would like it to be.

I need to count now based on contry and Request type. And i count in column B Sub Type.

Please have a look, really need this one.

Thanks in advance

Sincerely
Abjac

Working Jindon code.

Please Login or Register  to view this content.

HI Jindon. Wow i am so impressed by this code. Its working so great. I know i have to make some test to be sure of the result, But it seems that it works so great.
Thanks allot its and amazing code.

There can be some later on continue of this project. But this is a fantastic help for me.

Thanks
Have a nice day

Sincerely
Abjac

HI Jindon. Really need your help in my new thread. Its a continue of this thread you make a som amazing code for. Please have a look when you have time

Sincerely
Abjac

http://www.excelforum.com/excel-prog...html?p=3278895

hi , how do i post

HI Andriesp. I can see you are registrated. So you just press reply to thread if you wanna post with some help to my post. Or if you want to start your own thread, go up to the top left and press New Thread.

Sincerely

Abjac

HI ,

Thanks .

I have a count problem that is used in an offset function to automatically update my graphs . The sheet1 works fine but on sheet2 it does not.Im using this formula for sheet1 =offset(<range>,0,0,1,count(<range>)) and it works fine for sheet1.but in sheet2 there is a column C with quantities and coulmn d with percentages and so it goes on for everymonth of the year . the problem is for it not to count the percentage column and move on to the next .

Would you be able to help or what should i do ?

Hi Andriesp. I think its against the forum rules to ask for a new question in and existing thread.
What you can do is to make a new thread like i told you and it will be your own. And then see if can help you with that. Sorry i asked my self after something like this, and got the help here.
So try your own thread, and i am sure people will help here
Sincerley

Abjac