So I have a sheet with a bunch of data. I know it is easy to filter rows so that only data in a given column show. So I can filter by surname only for example, thats easy.
Is there a way to filter, with what would be in programming OR? So say I want to find all the rows with "blue" in columns C, D, E or F.
Is there a way to filter, with what would be in programming OR? So say I want to find all the rows with "blue" in columns C, D, E or F.