Filtering and removing the condition

Matthew Harrison 0
Viewed 19

I'm using the below formula and want to collect the data from the following columns but the last part of the formula I'm using is only collecting if the answer is 'Yes'. I want it to collect for both 'yes' and 'no' responses (or any response) whilst keeping the filtering the same as below.

=FILTER({'Form responses Original'!AM3:AM,'Form responses Original'!E3:E, 'Form responses Original'!B3:B, 'Form responses Original'!G3:G,'Form responses Original'!L3:M},UPPER('Form responses Original'!F3:F="yes"))
google-sheets
1 Answers

Then you no need FILTER() function. Just try-

={'Form responses Original'!AM3:AM,'Form responses Original'!E3:E, 'Form responses Original'!B3:B, 'Form responses Original'!G3:G,'Form responses Original'!L3:M}

Or with FILTER() like

=FILTER({'Form responses Original'!AM3:AM,'Form responses Original'!E3:E, 'Form responses Original'!B3:B, 'Form responses Original'!G3:G,'Form responses Original'!L3:M},UPPER('Form responses Original'!F3:F<>""))

Or can use QUERY() function.

Harun24hr0
Related