Hi All,
Please can you suggest a formula to return the nth non-zero number in a row of data, starting from the left.
Example: the 5th non-zero number in the following range, starting from the right would be 22:
52, 0, 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 left.
Example: the 5th non-zero number in the following range, starting from the right would be 22:
52, 0, 108, 5, 58, 0, 22
Thanks for your help!