For top group try:

=SUMPRODUCT(--(A5=$A$5:$A$23),--(C5<$C$5:$C$23))+SUMPRODUCT(--(A5=A$5:A$23),--(C5=C$5:C$23),--(D5<D$5:D$23))+SUMPRODUCT(--(A5=$A$5:$A$23),--(C5=$C$5:$C$23),--(D5=$D$5:$D$23),--(E5>$E$5:$E$23))+1
copied down

For bottom group try:

=SUMPRODUCT(--(A5=$A$31:$A$49),--(C5<$C$31:$C$49))+SUMPRODUCT(--(A31=$A$31:$A$49),--(C31=$C$31:$C$49),--(D31>$D$31:$D$49))+1
copied down