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

Created at: 2021-04-28 05:51:17
Questioner General

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!

Answer #1:

By: Isabelle Mosciski

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!

Answer #2:

By: Ms. Eulah Lang DVM

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)

Answer #3:

By: Mr. Vincent Stamm

.

Answer #4:

By: Elouise Quitzon Jr.

.

Answer #5:

By: Ms. Margarette McGlynn

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)

Answer #6:

By: Noe Rohan

Brilliant!