Remove Duplicate rows but Keeping the highest value

[JODomingos]

Hi Fellows.

I need to remove duplicate rows in column A, but I want to keep only the uniques with the highest value in column B. As I have information in columns C,D,E,F.... I have remove them but mantaining the entire row for those keeped.

Can you Help me?
Thanks in advance!!

 

[JODomingos]

For instance: It would remove row (4;12;16...)

 

[footoo]

Sort by column B, largest to smallest. Then use the Delete Duplicates tool.

 

[JODomingos]

But This deletion is going to be random, isn't?

 

[footoo]

But This deletion is going to be random, isn't?

I don't understand what you mean.
Why not try it on some sample data?

 

[JODomingos]

[I Tried footoo, but it did not working. Is it possible to have a macro for that? It would be great friend

 

[footoo]

In what way did it not work? Works for me.

 

[footoo]

Here's a macro based on the steps I suggested in post #3.

Sub v()
Dim lc& : lc = Cells(1, Columns.Count).End(1).Column
Dim lr& : lr = Cells(Rows.Count, 1).End(3).Row
With Range([A3], Cells(lr, lc))
    .Sort Key1:=[A3], Order1:=xlAscending, _
        Key2:=[B3], order2:=xlDescending, Header:=xlYes
    .RemoveDuplicates Columns:=1, Header:=xlYes
End With
End Sub