Start 21/10/2019 had play 8 match? New Player start 13/01/2020 need start 1 instead 8

[micope21]

Hi all,
in the file?
New Sign on player in highlight yellow
This formula I'm looking for from A sheet M23:AD23

As you see D4:D11 formula
IF(B$2="","",IFERROR(HLOOKUP($A4,A!$M$1:$AG$1,1,0),""))

G4:G11 formula
IF(D4="","",IFERROR(HLOOKUP(D4,A!$M$1:$AG$34,G$1,0),""))
Both formula work great from start of the season 21/10/2019 to finish?
But not if you sign up new player need start 13/01/2020 start count as 1 onward

Regard

[Bo_Ry]

Please try at

A!M2:AD2
=IF((M6>=MIN($AE$15:$AE$24))*(M9<>""),MAX($L2:L2)+1,"")

Sheet2
M4
=IF(K$2="","",IFERROR(HLOOKUP($A4,A!$M$2:$AG$2,1,0),""))

P4
=IF(D4="","",IFERROR(HLOOKUP(D4,A!$M$2:$AG$34,P$1-1,0),""))

[BMV]

array formula M4

Please Login or Register  to view this content.

Where 43843 is 13/01/2020

[micope21]

Tank you Bo_Ry and BMV,

Bo_Ry good formula? But problem what if I sign other player on different date?
Mean keep change formula every time new player date, which I don't want?

BMV formula very good So I change to this

Please Login or Register  to view this content.

So A!$AE$15 look up start date?
save me change any formula at all as it goes automatic? Give me 24 hours to play about for now? if thing so well? solve and rep

Regard