Hi,
I need to do this :
- see if Unique F3:F500 is in Part, at J3
- then for Unique F3:F500, need to have FIRST Max of G3:G500, at K3 and then Max of H3:H500 at L3
- so I got this , but I need to COMPARE G3:G500 with C (Nr1) and H3:H500 with D (Nr2), here I need HELP
Relation is this G > C and H > D
In attached a2, is removed because 2 (K3) = 2 (C4) But 23 (L3) < 24 (D4)
Or :
a7 is in list because 6 (K4) > 5 (C5)
c3 is in list because 8 (K5) = 8 (C8) But 4 (L5) > 3 (D8)
So SORT FILTER UNIQUE F3:F500 which are in Part, keep MAX G3:G500 and H3:H500 ( I believe I have this at J3:L500 )
and then keep ONLY G>C and or if G=C then keep H>D (I do not have this)
Thank you all
Bookmarks