EN VI

Google-sheets - How can I extract matching values, if checked, from three sheets?

In this example I'm trying to list or at least mark matching values from three sheets with the same statements.

If Person 1, 2 and 3 check the same statement it's supposed be listed in "Desired output".

I have tried FILTER, MATCH and IF but I'm not quite lucky with either or combined.

Solution:

Assuming the statements are in the same order in all the sheets, like in the provided example, you can use:

=BYROW({'Person 1'!A2:A11\'Person 2'!A2:A11\'Person 3'!A2:A11};LAMBDA(r;IF(AND(r);r)))

Tags

Pinned Posts

Tags: ads, Publishers, Ads Networks

Tags: Server, host, cloud

Author

Best Solution

Bot Lv 9

Keyword

Answer