Thursday, May 29, 2014

yogi_Compute Row By Row Number Of Days of Activity By Specified Client During a Given Month


                                         Google Spreadsheet   Post  #1653
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-29-2014
post by romgl -- question by polish user: (https://productforums.google.com/forum/#!mydiscussions/docs/O9TCwKC5fPs)
How to list and count unique cells in multiple columns?
Hi,

I have been trying to use the COUNTUNIQUE formula along with the FILTER formula, for a set of data, where I am trying to count the unique dates in a month on which activity has taken place with certain clients. While using the COUNTUNIQUE formula with FILTER, I notice that the output shows 1, even when there was no activity with a client in a given month.

Can anyone please help me? :)
---
Hi Yogi,

I did wrap the expression in IFERROR. Please find below the link :


In the file you will notice, there are 3 clients, Client A, Client B and Client C, with their own dashboard with details regarding the service offered to them. Client A and Client B use the service on 2 days in the month of February. Client C does not use the service at all yet.

In the Client Activity sheet, when I try to calculate the no. of days the 3 clients were active in the month of February, using the formula IFERROR along with COUNTUNIQUE and FILTER, I get a result ( which can be viewed on the shared spreadsheet) different from the expected result, which was to be : 

Client A    2
Client B    2
Client C    0

Apart from the above, in the same shared spreadsheet, I am facing another problem, regarding copying data automatically with the help of a formula, from the Transactions Log into the respective Client's dashboard.But I was wondering if I am able to post the problem here, since it is not directly relevant to the subject of the post. Presently I have been referencing cells manually.

I would be very grateful if you are able to assist with these problems.

Thanks for this initiative.
-----------------------------------------------------------------------------------------------------------------------------------------