VBA Evaluate Array then imput into range adjusting forumla in Array down with the Range

Hello and thank you in advance,

What I'm trying to do is have VBA calculate an Array Formula and then input into a range which is pretty straight forward. The issue is the Array formula doesn't adjust down the range.

for the example sheet I've attached here is the code that'll input the information I currently have.

Sub test()

Dim rng As Long

rng = Evaluate("=MAX(IF(A:A=A2,B:B))")
Range("C2:C15") = rng
  
End Sub

Issue is it inputs A2 as the reference cell in the full range.

for the attached what I want is for A2 to move to A3 for the next cell then A4 for the 3rd cell and so forth.

Was thinking a loop tell blank but the issue is the actual sheet will have a 200k lines so I might run into performance issues if I loop.

any help is appreciated.