excelbytes
Active Member
- Joined
- Dec 11, 2014
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I have a list like the attached. I want to use the FILTER function to filter only the rows that are green (there is no fill color on the data, I just shaded them for an example). The ones in green contain ABC only as one of the items in the string. Can this be done?