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.

**2019年04月20日26分26秒**

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! :)

**2019年04月20日26分26秒**

- How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?
- How do I properly clean up Excel interop objects?
- Oracle to Excel - PL/SQL export procedure
- Excel to CSV with UTF8 encoding
- DATEDIF on a Range in Excel
- Excel VBA: Custom functions that return a range of data
- Optimizing Excel formulas - SUMPRODUCT vs SUMIFS/COUNTIFS
- Excel task: comparing columns
- Comparing Snapshot Data in Excel (VBA?)
- Excel IF THEN statements

ADS