Hi
Let me see if I can explain what I'm trying to achieve here.
I'm trying to find the max value in column C based on several criteria. But the max value should repeated in those rows, where the criteria are met.
Column A, B, C is how the data is shown in my file. The other column is only for explanatory purpose.
In range A2:A5 the criteria is the same, however the values are different in column C. The max value in range C2:C5 is 100519, and should therefore be repeated in A2:A5.
Column F is the output/result.
[ATTACH=JSON]{"data-align":"none","data-size":"full","title":"excel max example.png","data-attachmentid":1219304}[/ATTACH]