I need to count the occurrence of each value in one column and group it by values in another. How would I do this?
我需要计算一列中每个值的出现次数,并将其按另一列中的值进行分组。我该怎么办?
1 个解决方案
#1
3
The following SUMPRODUCT will work:
以下SUMPRODUCT将起作用:
=SUMPRODUCT(($A$2:$A$6=H$1)*(ISNUMBER(SEARCH($G2,$B$2:$B$6))))
#1
3
The following SUMPRODUCT will work:
以下SUMPRODUCT将起作用:
=SUMPRODUCT(($A$2:$A$6=H$1)*(ISNUMBER(SEARCH($G2,$B$2:$B$6))))