Hi excel forum,
I am trying to create a formula that looks for the last cell with a value (being P in this case) and return the value in the cell above it.
Please see attached workbook for example and outcome i desire.
Any more information needed let me know.
thanks
Bookmarks