Forum Discussion
JFM_12
Feb 08, 2024Iron Contributor
Excel - Subtotal
Hello I would like to use the function subtotal within an Excel sheet. The function is =SUBTOTAL(103,'Page 1'!$A:$A) At the ende it would be with an offsset =OFFSET(Tabelle1!A1;...
JFM_12
Feb 15, 2024Iron Contributor
Hello
Thank you very much
I would like to use it in Power Automate
and the Formula is " =OFFSET(Tabelle1!A1;0;0;SUBTOTAL(103;Tabelle1!$A:$A);7)"
but I am getting an error. It might be because that cells are text an not numbers.
Regards
JFM_12
Thank you very much
I would like to use it in Power Automate
and the Formula is " =OFFSET(Tabelle1!A1;0;0;SUBTOTAL(103;Tabelle1!$A:$A);7)"
but I am getting an error. It might be because that cells are text an not numbers.
Regards
JFM_12
SergeiBaklan
Feb 15, 2024MVP
Do you generate Office Script for that?