Use last entry in column

Discuss the spreadsheet application

Use last entry in column

Postby Josellis » Wed Apr 16, 2008 12:47 pm

I was wondering if it was possible to use and display the very last entry placed in a list.

so in the example below, it would display "2" if for the left column, and "5" for the right column

1 6
8 6
2 5
- 1
- 5

And if I added a 4 after the 2, the 4 would be displayed.


Thank you
Josellis
 
Posts: 11
Joined: Wed Apr 16, 2008 12:11 pm

Re: Use last entry in column

Postby Hagar Delest » Wed Apr 16, 2008 2:17 pm

Here is a proposal with my little skills for Calc. Perhaps someone else will have a better idea with a more dedicated function.
I've used a temporary column to check the content of the cells. For blank cells, don't use anything or add an OR() condition in the test IF().

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
Attachments
Last entry.ods
(7.25 KiB) Downloaded 159 times
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 29002
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Use last entry in column

Postby Josellis » Thu Apr 17, 2008 12:58 am

sorry, but I don't quite get what you mean... Although I am computer literate, I don't use calc often, so do you think you could explain in more details?
Josellis
 
Posts: 11
Joined: Wed Apr 16, 2008 12:11 pm

Re: Use last entry in column

Postby Dave » Thu Apr 17, 2008 5:17 am

Here's how:

I used several columns. You CAN combine into one statement, but better not for clarity.

A column of values, say column A.

In B1 have this: =IF(A1<>"";1;"")
Copy down column B.

In C1 have this:=SUM(B1:B12)-1

In D1 you will see the result you want if you have this: =OFFSET(A1;C1;0)

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: Use last entry in column

Postby kingfisher » Thu Apr 17, 2008 6:11 am

I thought I had a link to a thread in the other forum, but I have links to several threads, so here they are:
http://www.oooforum.org/forum/viewtopic ... 414#130414
http://www.oooforum.org/forum/viewtopic ... 815#218815
http://www.oooforum.org/forum/viewtopic ... 695#159695
http://www.oooforum.org/forum/viewtopic.phtml?t=39863

The first link is the one you need. The others may expand on the subject.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests