have a large spreadsheet with many data columns and dates . Column A have dates and column B have weight in number. I want to calculate how many unique day we have above 30kg .
Calculated answer must be 2 as we have only 2 days which have above 30 value.
With your date in A1:B8
:
=SUM(--(FREQUENCY(IF(B2:B8>30,A2:A8),A2:A8)>0))
Enter as CSE
through CtrlShiftEnter