Looking for a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1564843%22%20slang%3D%22en-US%22%3ELooking%20for%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564843%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20need%20help%20to%20%3CEM%3E%3CSTRONG%3Eknow%20which%20formula%20I%20should%20use%20or%20which%20one%20would%20be%20the%20best%20to%20satisfy%20my%20need.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20an%20extract%20of%20some%20returns%20that%20I%20need%20to%20refund.%20Column%20H%20is%20filled%20automatically%20depending%20on%20the%20status%20of%20column%20F.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20would%20like%20to%20do%20next%20is%20to%20see%20in%20another%20sheet%20all%20the%20lines%20of%20the%20table%20where%20it%20is%20mentionned%20'A%20rembourser'%20in%20column%20H.%20Ideally%20i%20would%20like%20to%20have%26nbsp%3B%20in%20this%20new%20sheet%20column%20A%20%2F%20B%20%2F%20C%20%2F%20H%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20am%20clear%20enough%20and%20thanks%20in%20advance%20for%20your%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mikaelleo_0-1596536230737.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210186i26232B8FEB93BAA8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Mikaelleo_0-1596536230737.png%22%20alt%3D%22Mikaelleo_0-1596536230737.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1564843%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564865%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564865%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F748856%22%20target%3D%22_blank%22%3E%40Mikaelleo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20Power%20Query%20source%20table%20and%20return%20to%20another%20sheet%20filtered%20result.%20Another%20option%20is%20to%20use%20Advanced%20Filter.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564883%22%20slang%3D%22de-DE%22%3ESubject%3A%20Looking%20for%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564883%22%20slang%3D%22de-DE%22%3EIt%20is%20also%20possible%20to%20do%20this%20with%20conditional%20formatting.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Use%20conditional%20formatting%20to%20highlight%20information%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fuse-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fuse-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20If%20you%20liked%20one%20of%20the%20suggested%20solutions%2C%20please%20click%20on%20it%20as%20the%20correct%20answer%2C%20if%20possible%20with%20a%20like%20(thumbs%20up).%20If%20neither%20is%20the%20solution%20you%20are%20looking%20for%2C%20please%20give%20us%20a%20quick%20feedback.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Best%20regards%2C%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566540%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566540%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F748856%22%20target%3D%22_blank%22%3E%40Mikaelleo%3C%2FA%3E%26nbsp%3B%2C%20just%20curious%20on%20the%20screenshot%20you%20shared%20-%20it%20doesn't%20look%20like%20Excel%20(perhaps%20Google%20Sheets%3F)%2C%20so%20the%20Excel%20solutions%20may%20not%20apply.%20Apologies%20if%20I%20got%20that%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566573%22%20slang%3D%22de-DE%22%3ESubject%3A%20Looking%20for%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566573%22%20slang%3D%22de-DE%22%3EA%20file%20(without%20sensitive%20data)%20would%20help%20us%20all%20to%20offer%20you%20a%20quick%20solution.%20It%20is%20grueling%20to%20imitate%20the%20sheet%20in%20advance%20to%20send%20it%20as%20an%20example.%20%3CBR%20%2F%3E%20With%20sheets%20instead%20of%20pictures%20you%20get%20a%20quick%20solution.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nicolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

 

 

Mikaelleo_0-1596536230737.png

 

4 Replies
Highlighted

@Mikaelleo 

You may Power Query source table and return to another sheet filtered result. Another option is to use Advanced Filter.

Highlighted
It is also possible to do this with conditional formatting.

Use conditional formatting to highlight information

https://support.microsoft.com/en-gb/office/use-conditional-formatting-to-highlight-information-fed60...


If you liked one of the suggested solutions, please click on it as the correct answer, if possible with a like (thumbs up). If neither is the solution you are looking for, please give us a quick feedback.


Best regards,
Nikolino
I know I don't know anything (Socrates)
Highlighted

@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.

Highlighted
A file (without sensitive data) would help us all to offer you a quick solution. It is grueling to imitate the sheet in advance to send it as an example.
With sheets instead of pictures you get a quick solution.

Nicolino
I know I don't know anything (Socrates)