hello pejoi,
I think post https://www.excelforum.com/excel-for...ml#post5273235 has the same type of requirement

all formulas used in the sheets are array confirmed with control shift and enter.
The problem in managing the formula is the empty row between the data if details were continuous then I think formulas can be reduced to a larger extent