You’re offline. This is a read only version of the page.
Announcements
23
Hi all,
I would really appreciate your help with this one.
I am extracting all rows, where criteria is met for one column.
For example, I want to extract all rows where the Food column = Mango.
So that this would be the result:
I have a formula that works quite well on it's own which is: =FILTER(A1:C6, C1:C6 = "Mango")
However when I write this formula to excel through Power Automate Desktop, Excel adds the @ symbol in front of the formula to prevent spill. However, the spill is needed to return the rows!
This is what is returned currently:
Any help would be really appreciated!
Hello,
I think I have found the solution to this though it is a bit longer than originally hoped.
Step 1:
Under Actions, select the "Select cells in Excel Worksheet"
Then enter your intended workbook and the specific cell where you want to begin.
Step 2:
Under Actions, select "Send keys"
In here, ensure "Send key to" is set to "Window instance/handle" and then specifying your workbook.
Enter your original formula into the "Text to send" box, followed by {Return}. So your final formula would be =FILTER(A1:C6, C1:C6="Mango"){Return}
Once this is ran it will type the formula into your specified cell, followed by hitting the Return key and you will have the rows you want.
Share
Report
All responses (
Answers (
