Hi,

I am trying to basically search for the last non zero entry in a column and then return a value in the same row as that last non zero entry.
For example,

My first column of the table is time, second column is submission/marking of coursework (denoted by +1 & -1) and the third column is the number of courseworks awaiting to be marked. My aim is to search the third column for the last non zero value then return the time (from first column) that last non zero value appears.

Thanks in advance!