DISPLAY BOTTOM ENTRY ON A COLUMN

JOHNJOHNSON86786

How can I display the bottom (last entered) value of a column in a different "cell"

 

Andrée Starå

Hi John,

Here's an example using an INDEX function.

+1 is because it seems like you have one row empty in the top.

Depending on what you want to get the bottom value of, you could also use a MAX function. =MAX(Value:Value)

Try something like this.

=INDEX(Value:Value; COUNT((Value:Value)) + 1)

The same version but with the below changes for your and others convenience.

=INDEX(Value:Value, COUNT((Value:Value)) + 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting