Forum Discussion
Retrieving Full Rows For Any Cells Matching Search Query
Hi! I use Spreadsheets for pretty basic stuff but have been trying to get into more complex uses for my new job. Something I'm setting up is a database for customer calls we receive, cataloguing thei...
If without sorting I'd filter with headers
=FILTER( Table1[#All], ( Table1[[#All],[Color]] = selectedColor ) + ( Table1[[#All],[Color]] = Table1[[#Headers],[Color]] ) )Still works if sort by Numbers.
