Since yesterday I've been struggling with thousands of data in Excel. To reduce the amount of data I have, I decided to take the important ones and remove the others. This goes for identical strings with smaller values in this case.

Let's take a 3x2 data:

```
     A      B
  ---------------
1 | ABC123 | 10 |
  ---------------
2 | ABC123 | 50 |
  ---------------
3 | ABC123 | 300 |
  ---------------

```

So as you can see there are three identical strings, yet they all have different values. I just want to compare values between these identical strings, and then keep the string with the biggest value and delete its analogues.

This was just a simple example. There are tons of identical strings in my file which all have different values. And (somehow) the biggest one is the optimal one, so I really don't need the rest of them.

And finally my question is, what am I supposed to do to accomplish this? Any functions, formulas, anything?

I'd really appreciate your help.
Thanks a lot!