Help with excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2253253%22%20slang%3D%22en-US%22%3EHelp%20with%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2253253%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3EI%20am%20trying%20to%20construct%20a%20formula%20that%20deletes%20all%20rows%20except%20the%20highest%20value%20based%20on%20a%20matching%20identifier.%20There%20are%20hundreds%20of%20rows%20of%20identifiers%20and%20the%20value%20is%20a%20separate%20column.%20Thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2253253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hello,
I am trying to construct a formula that deletes all rows except the highest value based on a matching identifier. There are hundreds of rows of identifiers and the value is a separate column. Thank you.
1 Reply

@hmeehan38 

 

Without VBA and only with formulas, I don't think it's easy, if at all. But with VBA it is possible to provide a link in this direction here. On this page you will find many examples in this direction.

Clear entire row data except the first row using excel VBA

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)