Getting the cell reference - last cell with text

[DuncanG]

Thanks both for the QUICK response - I am amazed!! I was hoping for
simple formula as judging by your guys feedback, I am certainly
novice user. I will try get my head around the INDEX formula info.

Your help is much appreciated.