excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
i have this formula
=FILTER(W2:W2000,(AB2:AB2000>0)*(AB2:AB2000<>""))
but it returned #value error
because somewhere in ab col there's also an #value error
how can i ignore it?
i have this formula
=FILTER(W2:W2000,(AB2:AB2000>0)*(AB2:AB2000<>""))
but it returned #value error
because somewhere in ab col there's also an #value error
how can i ignore it?