SOLVED

MAXIFS

%3CLINGO-SUB%20id%3D%22lingo-sub-3456613%22%20slang%3D%22en-US%22%3EMAXIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3456613%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20trying%20to%20deliver%20the%20max%20of%20column%20B%20as%20long%20as%20the%20entries%20in%20column%20A%20are%20identical%3C%2FP%3E%3CP%3Ei%20have%20sorted%20column%20A%2C%20but%20the%20logic%20breaks%20down%20when%20the%20entry%20in%20column%20A%20changes%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3456613%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3456796%22%20slang%3D%22en-US%22%3ERe%3A%20MAXIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3456796%22%20slang%3D%22en-US%22%3EThis%20sounds%20do-able%20but%20there's%20some%20uncertainly%20about%20'identical'.%20Do%20happen%20to%20have%20a%20sample%20workbook%20or%20can%20paste%20a%20few%20rows%20as%20an%20example%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3456821%22%20slang%3D%22en-US%22%3ERe%3A%20MAXIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3456821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1410387%22%20target%3D%22_blank%22%3E%40DanSh3801%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20something%20like%20this%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20521px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20521px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20521px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376873i667B4E7BD58D962D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3456894%22%20slang%3D%22en-US%22%3ERe%3A%20MAXIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3456894%22%20slang%3D%22en-US%22%3EBeautiful%20%3A%20Take%20the%20rest%20of%20the%20day%20off%20!%20TY%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

i am trying to deliver the max of column B as long as the entries in column A are identical

i have sorted column A, but the logic breaks down when the entry in column A changes

3 Replies
This sounds do-able but there's some uncertainly about 'identical'. Do happen to have a sample workbook or can paste a few rows as an example?
best response confirmed by Hans Vogelaar (MVP)
Solution

@DanSh3801 

Do you mean something like this?

image.png

Beautiful : Take the rest of the day off ! TY