Por favor ayuda par estructurar una fórmula o algún tip para lo siguiente

%3CLINGO-SUB%20id%3D%22lingo-sub-2753722%22%20slang%3D%22es-ES%22%3EPlease%20help%20to%20structure%20a%20formula%20or%20some%20tip%20for%20the%20following%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2753722%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20afternoon%2C%20someone%20who%20can%20support%20me%20to%20find%20a%20formula%2C%20what%20I%20need%20is%20to%20look%20for%20the%20maximum%20value%20of%20column%20%22I%22%20based%20on%20column%20%22A%22%20by%20the%20groups%20that%20show%20the%20colors%20if%20they%20realize%20they%20are%20repeated%20so%20I%20frame%20them%20in%20groups%20of%20colors%20and%20of%20those%20groups%20evaluate%20column%20I%20taking%20out%20the%20Maximum%20and%20that%20they%20return%20the%20column%20H%2C%20%20it%20is%20worth%20mentioning%20that%20downwards%20there%20are%20many%20more%20hundred%20groups.%20The%20results%20you%20should%20get%20are%20marked%20with%20the%20red%20line%20for%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22luissanchezi_1-1631725710583.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310627iFF91824A0386134B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22luissanchezi_1-1631725710583.png%22%20alt%3D%22luissanchezi_1-1631725710583.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20attention%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2753722%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Buena tarde , alguien que me pueda apoyar para encontrar una fórmula , lo que necesito es buscar el valor máximo de la columna "I" en función de la columna "A" por los grupos que se muestran el colores si se dan cuenta están repetidos por eso los marco en grupos de colores y de esos grupos evaluar la columna I sacando el Máximo y que me devuelvan la columna H, cabe mencionar que hacia abajo hay muchos mas grupos cientos. Los resultados que debería obtener están marcados con la línea roja para ejemplo.

 

luissanchezi_1-1631725710583.png

Gracias por su atención

1 Reply

@luissanchezi 

what I need is to look for the maximum value of column "I" according to column "A"
That makes column "A" a criterion.
So can you share what the criteria are so that we can gain a full understanding of what is being isolated to get to the result?

Please complete your narrative and avoid omitting important details such as what is in column "A", the criterion that helps decide what kind of formula function to use.
For example:
[Your example here]