I've managed, using Power Query (green columns below), to get the rankings for week 24 to tally with your expected rankings in columns N:O :
2024-01-08_022418.jpg
I've done this by including the missing teams (par & udi) rank values from their most recent rank values before week 24 (from week 23 in this case):
2024-01-08_023145.jpg


However, with week 29, when the postponed par/udi fixture was played, there are 2 fixtures each played by udi & par:
2024-01-08_023531.jpg
Here, par and udi have both taken part in 2 fixtures each in week 29, you can see that cells BJ283:BJ284 are blank because it's taken account only the most recent (last) fixtures' rank values for those 2 teams when calculating ranking. I see you've got the same ranks (20 and 13) for week 29 when there are in fact different rank values which would alter their ranks.
How did you go about assigning those ranks/positions?