Hello,

Enter
=REPT(A2,(C2="VERREV")*(B2="G")*(SUMPRODUCT(--(A2=$A$2:$A$999),SIGN(($B
$2:$B$999="S")+($B$2:$B$999="W")),--($C$2:$C$999<"VERREV"))=SUMPRODUCT
(--(A2=$A$2:$A$999))-1))
and copy down, then replace by values and sort, for example.

Please note that Google groups tend to insert unwanted "-" characters
in long lines - you might need to search and delete those...(in my
published formula)

Regards,
Bernd