Forum Discussion
Solved
Show Last Record
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]...
=XLOOKUP([@[Trade Ref'#]],[Trade Ref'#],[[MTM ]],"",0,-1)
=XLOOKUP([@[Trade Ref'#]],[Trade Ref'#],[[MTM ]],"",0,-1)
Hi Detlef_Lewin
amazing. that worked. thank you very much!