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 shows. I can filter by surname only for example, that's easy.
Is there a way to filter with what would be in programming, an
OR? So, say I want to find all the rows with "blue" in columns C, D, E or F.
Am I going to need a macro for this?