The easiest would be to create a sort helper column:
assuming Name is col C, Stat is col D and Value is col E the formula in row 5 would be:
=TEXT(IF(C5=C4,E4,E5),"000000")&C5
The sort would then be on the column this formula is in (Descending) and the second key column would be the Stat column (Descending).
So the formula... if the Emp# is the same as the row above, use the row above value, otherwise use the value on the same row.