Hi everyone.
Given: A row with either positive real numbers or zero in each cell, i.e,
0 0 459.11 0 0 0 11 0 0 11198.1 0 0 0
I need to scan the row right to left, and return one of the following:
The number of zeros before the first non-zero value appears
The address of the last zero cell encountered or the first non-zero cell
The values are not arranged in any sort of order, and cannot be reordered, which killed my attempt at using an OFFSET/MATCH combination.
I think I could do this by simply parsing a text string, but I haven't figured out a way to automatically concatenate the entire row.
Oh, and if it's any help, the row will *always* be the same length.
My next step is VBA, but I've never worked with it, and I'd really like to avoid it if I can.
Thanks for any and all hints you can offer!
Bookmarks