formula help

[erhan_79]

Hi There ;

I need your help for below ıssue

I have Table A, it shows the list prices of Material A and Material B based some dates. As you can see the list prices that change based on days.I would like to create a new table that will list the latest date of prices of the materials. You can see with an example what I need.

Thanks in advance for your kind supports

[erhan_79]

@PaulDBrown  ok sorry you are right

[PaulDBrown · Accepted solution]

@erhan_79 

Please do not repeat the same question in different threads. It doesn't help others looking for a similar solution and also involves dispersed solutions/suggestions from people trying to help.

Thanks

[manikumar34]

@erhan_79 .

Take the latest date

Regards, 

Manikumar