Hi,
Each row in my spreadsheet may contain cells that contain the text "TD CONTRACT" & a reference eg.
Row 15: cell D15 = TD CONTRACT 12345, cell H15 = TD CONTRACT 22345, cell K15 = TD CONTRACT 32345 etc,
Row 16: cell M16 = TD CONTRACT 42345, cell R16 = TD CONTRACT 52345, cell AA16 = TD CONTRACT 62345 etc,
I need to show the cell reference in cell CA15 for the first occurance of finding the text value of "TD CONTRACT", ie excluding the reference in a range A15:BZ15
Would then copy the formula from CA15 to CA16 to pull cell value for row 16 etc.
Thanks
Steve
Each row in my spreadsheet may contain cells that contain the text "TD CONTRACT" & a reference eg.
Row 15: cell D15 = TD CONTRACT 12345, cell H15 = TD CONTRACT 22345, cell K15 = TD CONTRACT 32345 etc,
Row 16: cell M16 = TD CONTRACT 42345, cell R16 = TD CONTRACT 52345, cell AA16 = TD CONTRACT 62345 etc,
I need to show the cell reference in cell CA15 for the first occurance of finding the text value of "TD CONTRACT", ie excluding the reference in a range A15:BZ15
Would then copy the formula from CA15 to CA16 to pull cell value for row 16 etc.
Thanks
Steve