Show Last Record

[Tony2021]

Hello experts,

I need to show the last record in another column of this data set based on 2 criteria.

The criteria is I need to show the last record of [MTM] based on the MAX of [Valuation Date] but based on a grouping of [Trade Ref #].

I have attached the file with some comments of what I need. 

Let me know if its not clear. 

thank you very much. 

[#2 · Accepted solution]

@Tony2021 

=XLOOKUP([@[Trade Ref'#]],[Trade Ref'#],[[MTM ]],"",0,-1)

[#3]

Hi @Detlef_Lewin 

amazing.  that worked.  thank you very much!