Google Spreadsheet Post #2252
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Oct-02-2017
question by: Sam Larimer
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/IzfqE7AcArg;context-place=forum/docs
Need to filter results based on exclusion arrays (multiple strings)
SPREADSHEET IN QUESTION:
The title pretty much explains it. I am failing to have a manual import ignore certain strings if a specific contact was called or if the call was not connected. The "exclusion arrays" may change in nature and size.
Initially, I was playing around with the following
=Filter('All Calls'!D3:L50,
'All Calls'!F3:F50<>'All Calls'!A3:A12,
'All Calls'!J3:J50<>'All Calls'!B3:B7)
which clearly does not work as several of the filtered contacts are on the exclusionary array or it eliminates desired results. Feel free to edit space on tab "Location A" and thanks, in advance, for the help.
No comments:
Post a Comment