dynamic indirect() with sequenz() in adress() doesnt work.

Good morning.

I am obviously not a native English speaker, but I consider myself an advanced Excel user. I have attached a spreadsheet. In it, there are 2 pages. One called “Werte” with raw data in non-defined dimensions, and one called “Evaluation” which evaluates the raw data. #Captain Obvious

It is important to change the data area dynamically. The data evaluation will be executed column-wise (reference “evaluated area”). I tried the SEQUENCE() function, in combination with the ADDRESS() function and the INDIRECT() function.

This partly works. If you change the topmost input area column number, it changes automatically everything. The “Index”, “evaluated area” and the names change dynamically. I think I am close to the solution. Or close to tossing my computer out of the window. Not sure yet. But now comes the tricky part: The area covered with the blue squares should be dynamic too. The functions in the first column work, and I could mark them and pull them to the right, but that would be manual. It needs to be dynamic. My idea is to use the SEQUENCE() function, but it doesn’t work.

I can barely explain my problem in German, let alone in English. So again I am very sorry for my spelling. I will have Chat GPT correct my spelling. More and more clear instructions are in the attached file. This document could save me literally and non-exaggerated hundreds of hours of mind-numbing work. My boss is 200 years behind from a technical viewpoint, so explaining would be pointless.

Lots and lots of thanks for your help.

Morila