Excel 365 - Search table return true for each row

TRUE & FALSE Table

Hey All,

I need to return ALL the rows where TRUE is found so I can put it through a FILTER function.

E.g

S2:Z2 does not contain TRUE value return FALSE for Row 2

S3:Z3 contains a TRUE value return TRUE for Row 3

Thanks!

EDIT: Example of returned data

DATA Returned in AB

Returned Pending

https://stackoverflow.com/questions/66094820/excel-365-search-table-return-true-for-each-row February 08, 2021 at 09:21AM