I have Column A (QuoteNo) and column B (QuoteSubNo). There can be many QuoteSubNo values to 1 QuoteNo, but I just want to see the latest.

So, how do I filter QuoteSubNo on the highest number, based on a grouping of QuoteNo.

A B
1 1
1 2
1 3
2 1
2 2
2 3
2 4

So here I would just want to see QuoteSubNo's 3, 3, 4.

Thanks in advance.