Hi,
I am trying to find the last two data points that are not zero or blank. For the non-zero, I have
=IFERROR(INDEX(b6:b99,MATCH(0,b6:b99,0)-2),"-") to get the 2nd to last nonzero value.
=INDEX(b6:b99,MATCH(0,b6:b99,0)-1) to get the last nonzero value.
I have 2 other columns that have...