Hello everybody,
Thanks for taking my question.
I would like to autofill the following(either by using the autofill function or whatever other kind of solution):
=RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)
in a way that the column changes
the result should look like this:
=RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)
=RIGHT(Tabelle2!B$4;LEN(Tabelle2!B$4)-FIND(":";Tabelle2!B$4)-1)
=RIGHT(Tabelle2!C$4;LEN(Tabelle2!C$4)-FIND(":";Tabelle2!C$4)-1)
.
.
.
Yet, since I'm autofilling downwards (the formulas are in one column), it won't change anything. The number is not changing for the dollar signs - and this is okay. What I would like to change is the columns' reference.
Is there any possibility to do this?
Thanks for helping,
Cheers,
Andy
Bookmarks