I have an Attribute table similar to the one in my example Picture, just with thousdands of objects.
Some of the objects have the same value in "field 1" but different values in field 2. I want to write an expression that finds all objects with same values in field 1, among them compares the values in field 2 and memorizes the highest value and finally gives all the selected objects this highest value in field 3.
The expression should do 3 things. 1. the expression selects all objects with same values in field 1. For example in my image it selects the last object, the second last object and the object exactly in the middle.
It checks for the highest value in field 2 among them.
It gives all 3 objects the highest field 2 value in field 3.
Would that be possible?