How to show most recent entry in group of numbers

[Rich_Nuzzi]

Ok, I have been trying to do this for a while on my own with no luck.

I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I would like to do is figure out a way that I can see only the last entry for every serial number. My thought is to have a third field for a conditional formula. Something that just posts the number 1 if it is the most recent date. Then I can use a view to only see everything with the number 1 in that field. The problem is that I need to pull the most recent date for EVRY serial number group. Not just the most recent date over all. Hope that I am explaining this right. Here is an example of the a sample base:

Please help! Thank you.

[Ron_Daniel]

I believe @W_Vann_Hall 's answer in this thread might be a good building block (though you'd still need to figure out the final step of it working for each serial number).

[Ron_Daniel]

Sorry, forgot to include the link!
https://community.airtable.com/t5/other-questions/lookup-to-show-latest-entry/td-p/106261

[Rich_Nuzzi]

Saw that one. But that is also for two separate tables. I am only using 1 table. But I do appreciate the tip.

[AlxdS]

Same issue here. Did you find a solution?