Excel公式||如何计算列中出现的值 [英] Excel Formula || How to count occurrences of a value in column

问题描述

在计算公式以计算值在列中列出的次数时需要一些帮助。我将尝试解释以下要求。

Need some help in figuring out an formula to count the number of times a value is listed in a column. I will try and explain the requirement below.

下图显示了数据集的示例。

The below image show sample of data set.

要求是列出问题和措施每个客户。

如您所见，即使从单元格中聚集的值中，我们也需要找出单个唯一值，然后将其映射到相邻的一个或多个列中。

The requirement is to list out issues and actions per customer.
As you can see, even from values clustered in cell, we need to find out individual unique values and then map it against the adjacent column or columns.

推荐答案

它只需要一个额外的工作表/表即可执行。.

It just need an extra sheet/table to execute..

try：

A1 = a,b,c
A2 = b,c
A3 = c,b,a
A4 = c,a
A5 = b
B1 = ss
B2 = ss
B3 = dd
B4 = dd
B5 = ss
D1 = a
E1 = b
F1 = c
C7 = ss
C8 = dd

D2 =IF(FIND(D$1,$A2,1)>0,1,"") drag until F6

D7 =COUNTIFS($B$2:$B$6,$C7,D$2:D$6,1) drag until F8

D7：F8将是您想要的结果。尝试愉快。

D7:F8 will be your desired results. Happy trying.

这篇关于Excel公式||如何计算列中出现的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！