Dear Mr Debra Dalgleish,

The formula serves a limited purpose only as it won't work if there is no
data in column b against the specified row. Is there any other method that
will work even if there is no data in column B and the row is hidden