Aug 04 2020 03:23 AM
Hello there,
I would need help to know which formula I should use or which one would be the best to satisfy my need.
This is an extract of some returns that I need to refund. Column H is filled automatically depending on the status of column F.
What I would like to do next is to see in another sheet all the lines of the table where it is mentionned 'A rembourser' in column H. Ideally i would like to have in this new sheet column A / B / C / H
Hope I am clear enough and thanks in advance for your help :)
Aug 04 2020 03:36 AM
You may Power Query source table and return to another sheet filtered result. Another option is to use Advanced Filter.
Aug 04 2020 03:40 AM
Aug 04 2020 11:23 PM
@Mikaelleo , just curious on the screenshot you shared - it doesn't look like Excel (perhaps Google Sheets?), so the Excel solutions may not apply. Apologies if I got that wrong.
Aug 04 2020 11:38 PM