Forum Discussion
Formula if a cell contains a certain text then return that text in a different cell, otherwise move
Hi I need to create a formula that will copy the text from a cell in a different sheet if it contains the text "7X1", otherwise move to the cell below and if that one contains "7X1" copy that one, o...
Hi Sandra,
Supposing that the original data starts from cell A1 in Sheet1, please put this formula somewhere in the second sheet and then drag it down:
=IF(ISNUMBER(SEARCH("7X1",Sheet1!A1)),Sheet1!A1,"")
Regards
Hi
Thank you very much for your responses. Filtering will not help though. I tried the ISNUMBER formula and it’s not working. I need the formula to write the next 7X1 on the first sheet on a consecutive below cell on the second sheet with no black cells in between.
Thank you very much though
Thank you very much for your responses. Filtering will not help though. I tried the ISNUMBER formula and it’s not working. I need the formula to write the next 7X1 on the first sheet on a consecutive below cell on the second sheet with no black cells in between.
Thank you very much though