Forum Discussion
Tony2021
Jun 25, 2024Steel Contributor
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] 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.
=XLOOKUP([@[Trade Ref'#]],[Trade Ref'#],[[MTM ]],"",0,-1)
- Detlef_LewinSilver Contributor
=XLOOKUP([@[Trade Ref'#]],[Trade Ref'#],[[MTM ]],"",0,-1)
- Tony2021Steel Contributor
Hi Detlef_Lewin
amazing. that worked. thank you very much!