Hi!
I am looking for an Excel expression which I can put in a cell in the second sheet of a workbook in order to reference a cell in the first worksheet. If there is no value entered for the referenced cell, then I would like the cell above returned, if that is blank, then the cell above that... and so on.
For Example assume in worksheet one cells A1 and A5 have data and no data in any other cell. I would like these values returned,
For cells referencing A1 return A1
A2 return A1
A3 return A1
A4 return A1
A5 return A5
A6 return A5
A7 return a5
Thanks in advance.