Hi all!
I am looking for a formula that returns the unique cells from a range, under the condition that it contains a certain text.
The cells do contain more text than the criteria alone.
For example:
Screenshot 2022-03-28 154326.png
The desired formula should return the cells that contain (X) as part of the text in the cell.
Hope someone is able to help me!
Best,
Flexcel_
Bookmarks