Good afternoon to the community,
I am working with the file "Test4".
I have for example in the column N two values and I would like to display all the remaining values located in the row with this specific values.
My expected results is to obtain the table located in the table A19:K20.
Thank you for your help.
Capture d??cran 2022-09-17 170627.png
Please explain in more detail - I do not understand what you are showing us.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe this, copied down:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you for your proposal TMS but your formula doesn't work.
I would like to display the remaining values located in the row of "daba11" & and I would like to display the remaining values located in the row of "daba12". I reedit
the picture and the file.
Capture d??cran 2022-09-17 173339.png
Last edited by Luu4466; 09-17-2022 at 11:44 AM.
I put in orange "remained values".
like this
Country Bank Code bank Name agency Other Other 1 Other 2 Other 3 Other 4 Other 5 Other 6 blo azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds daba11 azqffgds youhou azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds daba12 azqffgds
or like this (other 5 is not oranged)
Country Bank Code bank Name agency Other Other 1 Other 2 Other 3 Other 4 Other 6 blo azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds youhou azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds azqffgds
@sandy 666 i would like to display the first proposal.
Attachment 796671
sure , so use Power Query
Please Login or Register to view this content.
or using a formula:
=FILTER(A2:K9,(ISNUMBER(MATCH(J2:J9,N2:N3,0))))
See file for translation into French.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you sandy666.
It is working, where did you put your formula in Power Query?
Attachment 796675
this is not formula, it's M-code
1. Data
2. Show Queries ...
3. double click on query on the right side
4. in new window tab Home and Advanced Editor
Thank you @sandy666 and @Glenn Kennedy. Both proposals are working very well and I discovered Power Query.
Have a goood day!
You are welcome
I was not even aware of column N values
Trevor, glad I'm not alone in missing the point... sometimes... oftentimes
Ok @TMS and @Glenn Kennedy, if i have difficulties in the future, I will be more accurate with the picture and my content.
It's true that is difficult to see column N values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks