need help

There is no file at that link.

hi Ashish here is the data,

Respondent IDDevice IDApp NameCategory

Hi,

Is this the result you are expecting?  Please check the numbers.  If my numbers are wrong, then share the correct numbers for some Categories so that i can rewrite my formula and tally my answer with your expected result.

hi Ashish, 

thanks for your reply.

though rather than counting the unique repspondents, i want to see how many same respid appears for a cateogory which have different apps installed. a respid represents a user id so if i am having a same user id for more than 10 times for a category for different apps, i need to count that user once in no of user with more than 10 apps bucket.

below pic is to show you the outcome required in case of app category social.

Hi,

Is this the result you are expecting?  Could you share a much larger dataset and the actual bucket sizes.  This is for me to check the efficiency of the formula.  Also, on the larger dataset, please share the sample output for 1 or 2 categories.  Lastly, if there are more column that you want to include in the dataset (say Country) and filter the table by a specific country, then share that result of 1-2 categories for that specific country as well.

Hi Ashish ,

Thx for your reply.yes it first look your solution seems right. i need this data only on category filter  for now. as per your comments i am sharting the large data set and expected result for 2 categories with actual bucket required,

https://1drv.ms/x/s!AqSgJWIdQo7Tiwht9pn6g5A54HC6?e=AxGtOh

Hi,

My solution works.  Please allow me time until Sunday to share my solution with you.

Thanks Ashish. I would wait for your reply.

Hi,

You may refer to my solution at this Blog article.

Hope this helps.

thank you Ashsih for your help here. however i am not able to see the solution as access is denied.

You are welcome.  Your Office's firewall policies are coming in the way.  Try to download the file from your Home Computer.

i tried it with my phone, and with my personal account as well, but failed.:(

I just downloaded the files without a problem.

hi Ashish, 

I am getting below error while trying it from my phone and desktop both. Please help me out or if possible please share your file on my id [email protected]

Hi,

I have replaced the download link.  Please retry.

am still having the same issue. i have contacted IT team and they assured me its not because of my system. 

hi Ashish, 

I tried accessing it from my home computer as well but getting the same message.

Thanks a lot Ashish. This is working as i wanted.

You are welcome.