Hi All,
Please can you suggest a formula to return the nth non-zero number in a row of data, starting from the right.
Example: the 5th non-zero number in the following string, starting from the right would be 108:
52, 40, 108, 5, 58, 0, 22
Thanks for your help!
Please can you suggest a formula to return the nth non-zero number in a row of data, starting from the right.
Example: the 5th non-zero number in the following string, starting from the right would be 108:
52, 40, 108, 5, 58, 0, 22
Thanks for your help!