Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 68

Warning: file_get_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 70

Warning: file_put_contents(/kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/logs/api-stats.txt): failed to open stream: No such file or directory in /kunden/362380_80937/vielhuber.de/wp-content/plugins/gtbabel/src/Log.php on line 91
Google Sheets: Formeln ausdehnen > Vielhuber David

Google Sheets: Formeln ausdehnen

Um innerhalb von Google Sheets Formeln auf ganze Spalten auszudehnen, empfiehlt sich der Einsatz der nützlichen Funktion ARRAYFORMULA. Leider funktioniert diese nicht in Kombination mit einigen anderen wichtigen Funktionen wie QUERY oder INDIREKT, weshalb eine komplette Individualprogrammierung der Logik mit Hilfe von Google Apps Script oder alternativ das manuelle Kopieren der Formel bis hin zur letzten Zeile übrig bleibt.


Als Alternative bauen wir uns für die zweite Variante eine kleine Hilfsfunktion, die in allen Tabellenblättern in Zeile 2 nach Formeln sucht und diese automatisch bis ans Ende der Tabellen kopiert. Dabei werden ARRAYFORMULA-Formeln automatisch ignoriert. Das Ganze fügt man über Tools > Skripteditor ein und lässt diese über Bearbeiten > Trigger des aktuellen Projekts zeitgesteuert 1x pro Minute laufen:

f9c221988a2b56958ffb5b0649bbdf27

Zurück