What I'm looking for is, in Row D i have different repeated values, and i want to keep from each individual value in D, the highest and lowest correspondent value in Row F, and delete the rest of the duplicates. This is just an example with 2 different "unloading's", I do however have and variable number of them.

Any idea how to solve this?

I didnt try anything, because i have no idea how to even start coding this. but the goal is that i end up with just 2 values in column F for each individual value in column D.

CodePudding user response：

You can try:

=query(D2:F,"Select D,min(F),max(F) where D is not null group by D")