Hi All, just wondering if someone can help me with finding the last numeric value in a row greater than zero. So far I have the following but I'm finding it will return a string if it happens to be the last value in the row.. but I'm only wanting the number greater than zero. WatchT1 is the name of the row (range) containing the values and strings
=INDEX(WatchCloseT1,,MATCH(0,WatchCloseT1,0)-1)
=INDEX(WatchCloseT1,,MATCH(0,WatchCloseT1,0)-1)