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.
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.
