[Solved] Pulling the last non zero from a row

[Raistlin212]

I've seen a few questions of this type but I can't figure out how to accomplish this seemingly easy task. C68 to AG68 populate with numbers each day. The rest of the yet unused columns are a zero. I need AH68 to be the last non-zero number. So for example, at the of the 15th there's 15 numbers around 100,000 each then 15 zeros. I need that 15th number to repeat at the end of the line. I've tried lookups and indexes but I can't seem to get it to work in Calc.

[Zizi64]

Try to use the
- MATCH(): this function can get the number of the first zero. (It will work as you expected is the data series not contain zero values, zeros are only on the end of the series.)
- OFFSET(): this function can get a value from a relative position based on the start cell.

Here is a sample file (there are column based data series in my file):

MATCH_OFFSET.ods

(11.6 KiB) Downloaded 71 times

[Bald Eagle]

This is usually WAY easier to do with a helper row/column.

See the attached spreadsheet for an example.