Forum Discussion
Unique value with criteria (Frequency formula)
Hello, in the table below I need to count how many distinct donors have given online (=3). The real file has 18,000 rows so I used FREQUENCY instead of COUNTIF as COUNTIF took too long to calculate u...
Shouldn't the result be 2 in your example? Only donors 1001 and 1002 have given online.
The following array formula confirmed with Ctrl+Shift+Enter should do what you want:
=SUM(--(FREQUENCY(IF(LEFT(YTD!B2:B35000,6)="Online",MATCH(YTD!A2:A35000,YTD!A2:A35000,0)),ROW(YTD!A2:A35000)-ROW(YTD!A2)+1)>0))
Yes indeed, it should be equal to 2. Thanks for the answer!