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?
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.