How can the Size of the Part be calculated on the fly? It should be the maximum Seq Number (shown in bold) for the Block and is required when Part is not empty.
PartSize.ods (12.8 KB)
Edit: cell F14 should be 1.
=IF(F2<>""; MAXIFS(D:D; A:A; A2; E:E; E2); "") and drag down.
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_maxifs.html
1 Like