Yet another VBA code help from formula

[Newbie73]

Hello, one more request (hopefully the last one!) to try to make one formula more efficient and VBA code tends to do the trick on a huge data sheet.

The following formula:

=LET(m,BYROW(Main!C3:Main!C40000,LAMBDA(r,MINIFS(Main!M3:Main!M40000,Main!C3:Main!C40000,r))),SORT(DROP(FILTER(HSTACK(m,Main!C3:Main!O40000),(LEFT(Main!C3:Main!C40000,LEN(G2))<>G2)*(Main!M3:Main!M40000=m)*(Main!C3:Main!C40000<>0)),,1),11))

It looks for different first 8 digits on the Main sheet Column C than the ones in Sheet2 G2 and if there is more than one identical value then choose the one with the oldest date on column M

Example spreadsheet provided:

test1.xlsx

Thanks!!

 

[Newbie73]

Any takers? Do let me know if you need any more information and thank you in advance!