Google Sheets: Results favorite (checked) entries in a new sheets

Hello RaimundP and Welcome to Excel Forum.
If you were to use Y instead of check boxes the process might be simpler.
In the attached file the array entered formula** used is: =IFERROR(INDEX(B$2:B$4,SMALL(IF($A$2:$A$4="y",ROW(B$2:B$4)-ROW(B$1)),ROWS(G$2:G2))),"")
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Note that in google I believe there is the option to type ARRAYFORMULA in front of the formula.
Let us know if you have any questions.

based on checkboxes, with just the year, make, and model as results....

this formula will give you the filtered list and the header row:

Please Login or Register  to view this content.

and this will just give you the data without the header row:

Please Login or Register  to view this content.

and this will give same results without the header row being included in the filter:

Please Login or Register  to view this content.

WOW!

Thanks for your help. "Query" will be the solution. Your tipps doesent wirk (german spelling, something else).

=QUERY(A!B3:E;"select B, C, D where B=TRUE")

runs absolutely well!


THANKS!!! You are GREAT!

Perhaps i was misspelling in my first trial and error runs...