Hello!
I have the following row with data:
0 0 0 1 6 4 2 0 1 0 0 3 4 5 3 2 3 1 0 0 0 0
I'm currently using the flowing formula to ignore leading zeros from the average:
=AVERAGE(INDEX($A$2:$V$2,1,MATCH(TRUE,INDEX($A$2:$V$2<>0,),0)):$V$2)
But I also need to ignore the trailling zeros, but I have no idead how to perform the same trick from right to left to find the first cell <>0
Any help will be much appreciated.
I have the following row with data:
0 0 0 1 6 4 2 0 1 0 0 3 4 5 3 2 3 1 0 0 0 0
I'm currently using the flowing formula to ignore leading zeros from the average:
=AVERAGE(INDEX($A$2:$V$2,1,MATCH(TRUE,INDEX($A$2:$V$2<>0,),0)):$V$2)
But I also need to ignore the trailling zeros, but I have no idead how to perform the same trick from right to left to find the first cell <>0
Any help will be much appreciated.