hi all,

Forgive me if this has been posted here. I'm new and am having a huge
problem searching for an answer on the net.
I have a column with item numbers, and another column with letters
listed where each letter is a version of that item number.
For example I might have item number 1234 and versions A, B, C and D.
Each version has its own row in Excel with the same item number.
What I want to do is view the highest version letter for each item
number. In the same sheet I would have several item numbers listed.

For example I would have something like this.
Item number Version
1234 A
1234 B
1234 C
6789 A
6789 B
6789 C
6789 D

What I want to view is the highest version letter of each so that it
would be listed in Excel as follows.
Item number Version
1234 C
6789 D

Can I do this using some sort of filter? If I need some sort of code
to do this then can someone tell me how I can enter this? Any help
would be very appreciated.
Thanks,
Shane