There’s FIRST() and LAST() that returns first and last data point of a subtable. I need the second to last data point, how can this be done ?

Hi,

You can use the COUNT formula inside a SUBTABLEROW formula. Your formula should look similar to the following:

SUBTABLEROW(A10,COUNT(A10)-1)

This formula means counting the number of subtable entries on cell A10, minus that value by one to get the second last subtable field value, and then applying the SUBTABLEROW formula to find that value.

1 Like