I would like to obtain the address of the:
- leftmost cell in range A3:J3
- rightmost cell in range A3:J3
that do not contain an error, and then divide the second by the first.
Basically I want to see the revenues growth in the most large time frame available for each line.
I have no idea on how to approach the problem except using a veeery long series of if(iserror(A1)=true;if(iserror(B2)=true;.....
but doesn't seem very productive.