Forum Discussion

Copper Contributor

Dec 30, 2021

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...

excel

Formulas and Functions

office 365

PeterBartholomew1

Silver Contributor

Dec 31, 2021

ChazS

As OliverScheurich suggests, with Excel 365, using FILTER is the only sensible option.

Index small color.xlsx12 KB

SergeiBaklan

Diamond Contributor

Dec 31, 2021

PeterBartholomew1

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.