I want to return ALL rows that contain a certain TEXT from a single column.
Sheet 1 contains data columns A to Z, in which data will be added over time. In Sheet 2, I want to return all rows that match a text string in Column T of Sheet 1. As new rows of data are added to Sheet 1, I want the formula to check for the specified text string in Column T and, if matched, copy that row (its entire content from all columns) in a new row in Sheet 2. I do not want any blank rows between data in Sheet 2.
I have tried several variances of Index/Match formulas using wildcards to search the text string, but searching for text istead of numerical values seems to be causing issues.