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: AB---------------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!
This is a good option. Requires you to sort so is a bit mor manual but overall far simpler.
Despite the fact that other answers might also be helpful, I think this one is the easiest one to implement and it totally worked like a charm, thanks a lot! :)