Google表格:计算不重复列中的X，其中Y [英] Google Sheets: Counting X where Y from column of uniques

问题描述

我不知道该怎么做.我可以在其他程序中做到这一点，但在这里不知道.

I have no idea how to do this. I could do this in other programs but no idea here.

https://docs.google.com/spreadsheets/d/1rXTCfG9wbFqPUtl9w8h4WcSolWEowxFk94O3nY6Ib30/

This is a list of characters in a game, matching accounts. Column B is the accountname. Column E is a rank the characters are given based on things. Column O is a list of unique accountnames. Objective is to populate Column P with a list of unique accountnames that are of rank Citizen. The logic is basically:

for( columnO )
{
if( columnO.columnE == "Citizen" )
 {
  columnP();
 }
}

解决方案

=UNIQUE(FILTER(Sheet1!B3:B, Sheet1!E3:E = "Citizen"))

Edit

Changed formula based on comments from @Victor Sheckels

The formula looks for all of the account names in column B that correspond to the rank "Citizen" in column E, and then uses UNIQUE() to return on only the unique values.

这篇关于Google表格:计算不重复列中的X，其中Y的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！