numbers last non blank item on a list with blanks in it

Hello,

I'm tracking data over time from different contributors. I want a footer that shows the last contribution from each contributor. Some cells will be blank in any given column and I can't use formulas in blank cells since the iPad form tool won't allow data entry on formula cells. Looks something like this:

Can this be done in Numbers?

Thanks!

If your column is B, this formula will do a search from the bottom up looking for the first cell that has anything in it.

=XLOOKUP(REGEX("."),B,B,"",2,−1)

.

.

If your column is B, this formula will do a search from the bottom up looking for the first cell that has anything in it.

=XLOOKUP(REGEX("."),B,B,"",2,−1)

Brilliant!