I have a workbook, where on Sheet 1 there is data from B5:E (the number of
rows may be different on different workbooks).
The word 'Status' appears numerous times within Column B. I would like to
have a formula on Sheet 2 that looks for every instance of the word 'Status'
and lists the value of the cell immediately above it.
Any ideas?