Hi,
I have a spreadsheet that contains the following information:
1) Col A - time stamps (number of entries can change).
2) Col B to Col M contain data corresponding to ColA. Each col is
independent of each other. From ColA thru M all have same number of rows.

I need to be able to find the largest number from ColB to ColM on the
last none zone row. Therefore, if there are 10 rows, I am only insterested
in getting the data on the 10th row. Once the value is retrieved, I'll need
to lookup the 1st row on that col which contains the name of the test. say
ColC has the largest number, then it needs to return C1.

I hv tried using offset along w/ countA, i can't quite seem to put them
together.

Thanks,