SOLVED

MAXIFS

Copper 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
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@DanSh3801 

Do you mean something like this?

image.png

View solution in original post