Returning a Value from a table based on the last non zero entry in the table

[samz93]

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!

[AlKey]

Since you did not provide any cell range references I would only suggest a concept that you can adapt to whatever you are trying to do:

This assumes that data in Column A range A2:A8

***enter this array formula in C2 using Ctrl+Shift+Enter combination

=INDEX($A$2:$A$8,LARGE(IF($A$2:$A$8<>0,ROW($A$2:$A$8)-1,""),1))

	A	B	C
1	Values		Last non-0
2	2		7
3	65
4	12
5	25
6	0
7	0
8	7

[samz93]

Hi thanks for the quick reply! I have tried to adapt that formula but keep receiving error. Maybe it'll help if you can see the table i wish to able it to. I have posted the spreadsheet. The table i am referring to is the big two way table to the right. The red cell is where i wish for the value to be appear. I aim to check the biggest value in the last row of the table (row 112) and according to the biggest value, i would like the corresponding column title to be entered in the cell. thanks again!

[FDibbins]

Not sure if there is a problem with your file???????? I opened it, cannot move anywhere in the sheet - or even select other sheets. My excel in fact seems to have hung, I cannot even select any other workbooks I had open!!!!

[FDibbins]

OK excel eventually crashed

[AlKey]

Unless my excel is colorblind, there are no red cells in your workbook. It would really help if you could answer few simple questions: What the sheet name, what is the cell that you want your formula be (A1 or C2, etc) and what is the range of cells that the values is located.

Thanks

[samz93]

Apologies. This could be due to the fact i have two large data tables on the spreadsheet therefore it does run pretty slow