Hi All. I have a some number ranges that I need to reduce down taking the
number and another variable into consideration. For example, the following
list:

1234 A
123 A
12 B
12345 A

can all be reduced down to:

12 B
123 A

Is there a way to do this in excel so that it goes through the list and
shortens a list down so that it contains only unique entries?

thanks!