Following situation occurs with an export File used for calculations. Calculations may contain up to 2000 rows.
I want to determine from each row (preferable with a function) whether the row is for a main-title or subtitle. All Positions are Named "NORMAL" in Column A, Both Main-title and Subtitles are named "Bereich" in Column A. The Subtitle-cells have in common that the Function SUM is being used in Column B, For Main Titles Additions are being used.
Column A /Column B
BEREICH /=AU4+AU36
BEREICH /=SOM(AU7:AU35)
NORMAL /=D7*F7
NORMAL /=D8*F8
I am looking for something like =IF(MID(B2;1;3)="SUM";"SUBTITLE";"") But this just works for text, not for searching within a formula.
Apart from pasting the formula as text, is there another way to solve this?
Bookmarks