Hi
I have an excel sheet (photo below) with column B showing "SafetyFeature", and column C, D, and E showing the relative building component. For example, in row 4, the safetyfeature 1 applies to building components 1 and 2.
What I need to see in the results is the safetyfeatures which apply to either building component 1 "or" 3. This means wherever item 1 or 3 is being showed in any of the cells across a safetyfeature, that safety feature is expected to be showed up using the filter.
If I use the regular filtering, it would show those safety features which apply to 1 or 3 in column C, "AND" 1 or 3 in column D, "AND" 1 or 3 in column E. This is when I need to show those safety features which apply to "EITHER" 1 or 3 in column C, "OR" 1 or 3 in column D, "OR" 1 or 3 in column E.
Any idea?
I have an excel sheet (photo below) with column B showing "SafetyFeature", and column C, D, and E showing the relative building component. For example, in row 4, the safetyfeature 1 applies to building components 1 and 2.
What I need to see in the results is the safetyfeatures which apply to either building component 1 "or" 3. This means wherever item 1 or 3 is being showed in any of the cells across a safetyfeature, that safety feature is expected to be showed up using the filter.
If I use the regular filtering, it would show those safety features which apply to 1 or 3 in column C, "AND" 1 or 3 in column D, "AND" 1 or 3 in column E. This is when I need to show those safety features which apply to "EITHER" 1 or 3 in column C, "OR" 1 or 3 in column D, "OR" 1 or 3 in column E.
Any idea?