Get last date of an event

Post your questions, bug reports and suggestions here for PlanMaker 2016 for Windows.

Moderator: SoftMaker Team

Post Reply
ccdrop
Posts: 6
Joined: Tue Mar 28, 2017 5:55 pm

Get last date of an event

Post by ccdrop » Fri Apr 14, 2017 3:04 am

None of the Excel or other examples I'm finding online work in planmaker to find the last time something was done in a table.
So how do I go about doing this in PlanMaker:


Question: How to find the last date of event 1?

Table used:

Event | Date
1 | 3/11/17
2 | 3/3/17
1 | 4/1/17
2 | 4/3/17
1 | 4/4/17
....etc....

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7924
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Get last date of an event

Post by sven-l » Tue Apr 18, 2017 11:07 am

Which function exactly do you use to do it in MS Excel?
Sven Leßmann
SoftMaker Software GmbH

ccdrop
Posts: 6
Joined: Tue Mar 28, 2017 5:55 pm

Re: Get last date of an event

Post by ccdrop » Wed Apr 19, 2017 7:15 am

=MAX(IF("1"=A2:A9000,B2:B9000))

In Google spread sheets:

=max(filter(B:B,A:A="1"))

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7924
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Get last date of an event

Post by sven-l » Thu Apr 20, 2017 8:25 am

This function is not yet available in PlanMaker. I will refer this to our product management as a suggestion for the future.
Sven Leßmann
SoftMaker Software GmbH

Post Reply

Return to “PlanMaker 2016 for Windows”