Excel公式：根据另一行中的对应值计算一行中的唯一值(Excel Formula: Count Unique Values in a Row Based on Corresponding Value in Another Row)

 我已经尝试了很长一段时间，我已经尝试了一些不同的方法，无法得到我正在寻找的任何结果。 我在Excel中有一个类似于下面的数据集（为格式化道歉，我还不能发布图像）： 
 
          Manager 1     Manager 1       Manager 2        Manager 2
Issuer 1          0           0               0                  0  
Issuer 2        100         100               0                100
Issuer 3        100           0             100                  0
Issuer 4          0           0               0                  0
 
 我正在尝试计算与每个Manager相关联的唯一发行者的数量（“关联”被定义为具有> 0的值）。 每个Issuer都是唯一的（仅在列表中显示一次），但每个Manager可以多次显示。 我想为每个经理人拿一个号码。 那么，结果如下： 
 
 经理1：2（不是3，因为发行人2为经理1出现两次，我正在寻找唯一的值，所以它只计算一次） 
 
 经理2：2 
 
 我可以编写一个公式来计算每个Manager的大于零结果的总数，但不能计算唯一大于零结果的总数。 我尝试过SUMPRODUCT和DCOUNT的变种，但我没有得到正确的结果。 我也可以为我想要实现的目标编写一个宏，但我更喜欢一个公式（部分是为了看看它是如何完成的挑战）。 任何帮助是极大的赞赏！ 

I've been trying to get this one for quite a while and I've tried a few different approaches and can't get the result I'm looking for with any of them. I have a dataset similar to the below in Excel (apologize for the formatting, I can't yet post images):
 
          Manager 1     Manager 1       Manager 2        Manager 2
Issuer 1          0           0               0                  0  
Issuer 2        100         100               0                100
Issuer 3        100           0             100                  0
Issuer 4          0           0               0                  0
 
I'm trying to count the number of unique Issuers associated with each Manager ("associated" being defined as having a value > 0). Each Issuer is unique (only shows up once in the list) but each Manager can show up multiple times. I'm trying to get one number for each Manager. So, the results would be as follows:
 
Manager 1: 2 (not 3, because Issuer 2 shows up twice for Manager 1, and I'm looking for unique values so it would only be counted once)
 
Manager 2: 2
 
I can write a formula to count the total number of greater-than-zero results for each Manager, but not the total number of unique greater-than-zero results. I've tried variations of SUMPRODUCT and DCOUNT but I'm not getting the correct result. I could also write a macro for what I'm trying to achieve but I'd prefer a formula (partly for the challenge in seeing how it can be done). Any help is greatly appreciated!

原文：https://stackoverflow.com/questions/20753066