Complex Unique-Filter-Sort Question

[ionelz]

My Range is E4:H500, with empty rows on bottom
E, F,G is string, H is numeric
I need this :
Filter E4:H500 by :
01. Unique of E4:E500
02. Sort by H4:H500
but here is the problem I have : in H I need the MAX value
So In E say aaa appear 7 times, in H can have different values, I need the MAX value from H
Example
aaa bbbb cccccccc 1
aaa bbbb cccccccc 3
zzz dddd ffffffffffff 2

result is
aaa bbbb cccccccc 3
zzz dddd ffffffffffff 2

 

[ionelz]

Is anyway you could add another column sort ?
Now is sorted by column 4 only
Could you add after column 4 sort, column 3 sort ?

 

[Peter_SSs]

Is this what you mean?

ionelz.xlsm
	E	F	G	H	I	J	K	L	M
1	a	z	66	1		b	z	100	50
2	a	z	66	1		b	z	20	50
3	a	z	18	3		a	z	10	40
4	a	z	40	5		a	z	66	6
5	b	z	100	6		a	z	40	6
6	a	z	47	2		d	z	100	4
7	b	z	100	50		c	z	100	4
8	a	z	10	40		c	z	90	4
9	d	z	100	4		c	z	88	3
10	c	z	90	4		a	z	18	3
11	c	z	88	3		a	z	47	2
12	a	z	40	6
13	a	z	66	2
14	a	z	66	6
15	c	z	100	4
16	b	z	20	50
17
Filter (2)

Cell Formulas
Range	Formula
J1:M11	J1	=LET(u,UNIQUE(FILTER(E1:H500,H1:H500=MAXIFS(H1:H500,E1:E500,E1:E500,F1:F500,F1:F500,G1:G500,G1:G500))),f,FILTER(u,INDEX(u,0,1)<>0),SORTBY(f,INDEX(f,0,4),-1,INDEX(f,0,3),-1))
Dynamic array formulas.

 

[ionelz]

yes, thank you so much !

 

[Peter_SSs]

Cheers. You're welcome. Thanks for the confirmation.