The unique items in D are: 4,3,2.
I wish to extract 3 rows for each D value, For each row, provide the first row that this D value appears.
I tried using
=query but it doesn't support grouping or subqueries. I tried to use
arrayformula but it doesn't support the
Do you have an idea?