Does the single-cell formula at cell I3 work?
Probably not, if you're using Excel 2016.
But are the results correct?
I'll look at this further later…
update:
In sheet Aufbau (2) of the attached (updated file) there's a Power Query (built in to Excel 2016) solution; change the source data (blue table on the left) then update the result table in cell I2 by right-clicking that result table and choosing Refresh.
|