Calculate the rank based on the two or Three criteria

Question

I need your support to find the rank considering below

1. PO Number
2. Group
3. Start date

In this need to calculate a different rank for all PO separately and also Need to pick the rank based on n the date but need to consider PO and Group separately

The result need to come as showing the number in Rank (Column D)

Answer 1

=LET(d,   A4:C18,
     a,   INDEX(d,,1),
     b,   INDEX(d,,2),
     c,   INDEX(d,,3),
MAP(      SEQUENCE(ROWS(d)),
LAMBDA(   r,
SUM((a=INDEX(a,r))*(b=INDEX(b,r))*(c<=INDEX(c,r))))))

This will be easier to maintain if your range changes. All you need to do is expand the range d.