Table, A1/H1 - A100/H100.
Column H rows have a lot of text and I want to sort the table by a key word ( blue, red and green) within the text of each row.
Is it possible?
Or what about a formula for column I that searches column H for the key words ( blue, red and green) and puts in the key word...