Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
79
Views
Topic starter
I am new at PQ.
If in Sheet1 column E contain "Yodle" and Column G contains "Doodle" can I move to Sheet 2*? Filter threw the rows and move to other sheet if the criteria in a row is meet.
Posted : 03/06/2017 2:58 pm
Hi Billn,
Yes, you can write 'if' statements in Power Query to test columns meet criteria and then filter the rows out that don't so all you're left with are the rows you want.
Mynda
Posted : 04/06/2017 5:38 am
