Working notes on Difference: Unique.
Difference.
=FILTER( Total!B2:B, NOT ( COUNTIF('Total-discarded'!B2:B, Total!B2:B) )).
Unique
Unique().
Not empty.
=Sort(F2:F, LEN(TRIM(arrayformula(F2:F)))>0)).
Updated:
2026 Aug 19
Working notes on Difference: Unique.
Difference.
=FILTER( Total!B2:B, NOT ( COUNTIF('Total-discarded'!B2:B, Total!B2:B) )).
Unique().
Not empty.
=Sort(F2:F, LEN(TRIM(arrayformula(F2:F)))>0)).
