How to calculate the TIME of last ORDER

[uacg0009]

Hi all,

I have the data like below and also have a list of ITEM:

The ORDER is 1 to n order by the TIME, now what I want to calculate is:

if I choose C in the list of ITEM, I want to calculate the TIME of last ORDER of the VIP who purchased C.

it also means that I want to know what the TIME that corresponds to ORDER - 1 is.

if one VIP bought C twice or more, we choose the min(ORDER)

And at this example, the result what I want is the Table2 below:

I did a chart but the final function didn't work.

I hope you know what I want and if you have any problems pls feel free to tell me.

Thank you!!

[uacg0009]

Hi Michael Gardner,

Noted with thanks~