Exclude a string from ARRAYFORMULA

Question

So i'm using ARRAYFORMULA to grab a list of strings from another sheet. I only want strings which don't contain "USD". How do I program my cell to collect data which excludes the string "USD"?

=ARRAYFORMULA(Account!A4:A100)

score 2 · Accepted Answer · answered Apr 02 '22 at 15:12

2

use:

=FILTER(A4:A100; NOT(REGEXMATCH(A4:A100&""; "USD")))

answered Apr 02 '22 at 15:12

player0

124,011
12
67
124

Exclude a string from ARRAYFORMULA

1 Answers1