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 :
https://docs.google.com/
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.
-----------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment