How to show only max date values?

[#1]

Hi,

I have data as below in excel.

NO	From	To	Name	date
432434	Sales	Funcorner	XX	06/05/2015   12:56
432434	Sales	Funcorner	XX	12/06/2015   15:04
432434	NO	Road Tax	XX	12/06/2015   14:30
432434	Workshop	Road Tax	XX	13/04/2015   16:15

I need table to show max date when To ='Road Tax'  (in this case the table should show 12/06/2015 14:30) and max date when To ='Funcorner'  (in this case the table should show 12/06/2015 15:04)

Please can anyone suggest me how to do this.

Thanks.

[MarcoWedel]

Hi,

one solution could be:

expression:

=Timestamp(Max(date),'DD/MM/YYYY hh:mm')

If you also want to show the corresponding From-value, you could use the expression

=FirstSortedValue(From, -date)

hope this helps

regards

Marco