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,
if you just want to know the data then use "Filter -> Contains". If you really need to copy then use "Advanced Filter".