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.
Bookmarks