Dermot
Board Regular
- Joined
- Aug 11, 2006
- Messages
- 199
- Office Version
- 365
- Platform
- Windows
Just thought I'd post this in case it hadn't been noticed already
FILTER is documented as taking a range and filtering on some criteria
I accidentally discovered you can use a formula instead of a range, so you can write
= FILTER( A1:A5*B1:B5-C1:C5, B1:B5>0)
which I think is pretty powerful!
FILTER is documented as taking a range and filtering on some criteria
I accidentally discovered you can use a formula instead of a range, so you can write
= FILTER( A1:A5*B1:B5-C1:C5, B1:B5>0)
which I think is pretty powerful!
