79156361

Date: 2024-11-04 17:04:04
Score: 0.5
Natty:
Report link

Combine COUNTUNIQUE with COUNTIF and MIN. Something like:

=COUNTUNIQUE(C53:C72) - MIN(COUNTIF(C53:C72, "blank"), 1)

Don't have access to Google Sheets now to test it.

Reasons:
  • Low length (1):
  • Has code block (-0.5):
Posted by: ENIAC