I want to display the output as like in sheet2
I want to display the output as like in sheet2
Try Pivot Table or possibly Power Query.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Using Special-K suggestion for Power Query, see the Mcode below and then check my signature for Power Query tutorials if you are not familiar
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
in excel where can i need to paste this code? pls say step procedure
Look at my signature in post #3 and click on the last two to learn how PQ works.
I can't understand this, pls say simple formula steps like this:
=COUNTIFS(Sheet1!$K$2:$K$35,'Sheet2'!$F5,Sheet1!$P$2:$P$35,">="&$C$3,Sheet1!$P$2:$P$35,"<="&$D$3,Sheet1!$O$2:$O$35,"San")
It's not a formula.
OK - here's what you need to do:
1. In the original workbook select the whole of your source table (A1 to D14).
2. With this range selected, go to the Data ribbon and click on From Table/Range in the Get & Transform area of the ribbon (on the left). This will load the table into PowerQuery.
3. In the PQ editor that is now open, click on Advanced Editor in the ribbon (near the left).
4. In the dialog that opens, replace all the code that appears with the code below, then click on Done (bottom right).
5. Finally, click on Close & Load at the far left of the PQ ribbon.
The M Code:
Please Login or Register to view this content.
Last edited by AliGW; 05-31-2019 at 02:32 AM.
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.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
"A2" Extract Unique :copy paste down.Formula:Please Login or Register to view this content.
"B1"copy paste to c1 & d1Formula:Please Login or Register to view this content.
By press ctrl+shift+enter
"B2"Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thanks a lot. Working fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks