Formula Library

Excel Formula To Count Unique Values By Status Pending In Support Ticket Text

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

Quick answer

Count unique values by status Pending in support ticket text.

Unified formula

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

How it works

Need a custom version?

Related formulas

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 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.

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.