@Daniel_Fichtner - Can you please take a look at my post…i have provided two solutions (one using find last row/column activity and other using formula)…
I see in your case data is growing and you want to dynamically use that range …
Yes you can do it… link to my post …
Please check and let me know…
ashokkarale
Anil_G
ppr
shyamala_shyamu
Josh_James
m-takeda1
Shahabaz
harshika.10732998
sharazkm32