公式库

Excel Formula To Count Unique Values By Status Active In Transaction Text

Count unique values for status Active in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Count unique values by status Active in transaction text.

统一公式

ExcelGoogle SheetsWPS
=COUNTA(UNIQUE(FILTER(B:B, A:A="Active")))

使用说明

需要定制版本？

相关公式

Excel Formula To Count Unique Values By Status Paid In Transaction Text

Count unique values for status Paid in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Unique Values By Status Pending In Transaction Text

Count unique values for status Pending in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Unique Values By Status Cancelled In Transaction Text

Count unique values for status Cancelled in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Unique Values By Status Refunded In Transaction Text

Count unique values for status Refunded in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Unique Values By Status On Hold In Transaction Text

Count unique values for status On Hold in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Unique Values By Status Paid In Imported Csv Text

Count unique values for status Paid in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.