Forum Discussion
Show value of last cell to the left that has a value
Column A has unique references of reports. Columns B to F show versions of those reports, version 1, version 2 etc...... in the cells of columns B to F is a number (4, 7, 2 etc) But not all report...
Is it sufficient simply to count the number of entries on each row? If so,
= SIGN(versions<>"")
will flag each version of each document with a 1. There are very few functions that will process such a 2D array to give a column of results; the main one is MMULT. Such matrix multiplication can give the number of versions for each document
= MMULT(SIGN(versions<>""), SEQUENCE(COLUMNS(versions),,,0))
I have additional functions such as
= SUMROWS(SIGN(versions<>""))
but they are not generally available.