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...
If all you need to do is summarize the occurrences of "7X1" in another sheet, then why not use a PivotTable? There's no need for complex formulas, or separating the data that way.