Hi,
The attached excel sheet, tab Group Scheme A & B has seven names which appears in both columns A and M Example HDFC Bank
I do not want to see any other rows except these 7 which are duplicated in A and M
REST OF THE Columns should remain as it is. How to alter the query Group Scheme A & B to get this output
If I understand your needs correctly as you did not provide a mocked up solution then
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Can you please add this my excel sheet
Do you not know how to copy and paste?
Re: Power Query - Display only if dupicate in two columns
without additional column
Please Login or Register to view this content.
Last edited by sandy666; 01-29-2023 at 04:46 AM.
Did copy paste, could not make it work. Sir, I am a college student and not an expert in excel. I am learning power query for my project and this is the last step i need to complete hence seeking help
Have attached my file without group query HUBMLE REQUEST TO HELP
Example Scenario
Schema A and Scheme B both has HDFC Bank
So Ouput should be
Stock Invested Scheme A Holding % Scheme B Holding &
HDFC Bank 4.2% 3.90%
Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").
It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.
- Follow this link to learn how to install Power Query in Excel 2010 / 2013.
- Follow this link for an introduction to Power Query functionality.
- Follow this link for a video which demonstrates how to use Power Query code provided.
Since you are a student, it is more important that you try to solve it with the help we provide and not have us do your work for you. Education is about learning and not about just getting the right answers to pass. Your request in the last post does not resemble the request you made in the first post.
Last edited by alansidman; 01-29-2023 at 05:00 AM.
Sir I have the add on. Only requesting one help as in the above post
@alan
thanks for the links in post #7. Unfortunately, the third link ( using provided PQ code) does not work. Do you have any other info please ? Thx
Re: Power Query - Display only if dupicate in two columns
is that what you want?
Stock Invested in % of Total Holdings A % of Total Holdings B HDFC Bank Ltd. Indian Hotels Company Limited Cummins India Ltd. Bosch Ltd. UPL Ltd. Canara Bank Voltas Limited
Please Login or Register to view this content.
Last edited by sandy666; 01-29-2023 at 05:29 AM. Reason: correction
Ye Sir Humble request to please incorporate in this attachment
I suggest to read post#4
Sorry am done with sandy666
I am extremely glad to all moderators, contributors and authors for creating such a great forum
Thank you I am happy that such forum exists wherein people like me get help almost instantOriginally Posted by sandy666
is that what you want?
Stock Invested in % of Total Holdings A % of Total Holdings B HDFC Bank Ltd. Indian Hotels Company Limited Cummins India Ltd. Bosch Ltd. UPL Ltd. Canara Bank Voltas Limited
Please Login or Register to view this content.
my pleasure
if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)
Pepe
Interesting, I clicked on the link and it opened ok. Here is the same link with the full URL
https://excel.solutions/2017/11/powe...te-code-video/
Thanks Alan, works great now ( perhaps a VPN problem on my side)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks