+ Reply to Thread
Results 1 to 10 of 10

I want to compare and bring output to sheet2

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    I want to compare and bring output to sheet2

    I want to display the output as like in sheet2
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: I want to compare and bring output to 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.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: I want to compare and bring output to sheet2

    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

  4. #4
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: I want to compare and bring output to sheet2

    in excel where can i need to paste this code? pls say step procedure

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: I want to compare and bring output to sheet2

    Look at my signature in post #3 and click on the last two to learn how PQ works.

  6. #6
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: I want to compare and bring output to sheet2

    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")

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,422

    Re: I want to compare and bring output to sheet2

    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.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,422

    Re: I want to compare and bring output to sheet2

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  9. #9
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: I want to compare and bring output to sheet2

    "A2" Extract Unique :
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy paste down.
    "B1"
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy paste to c1 & d1
    By press ctrl+shift+enter
    "B2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files


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

  10. #10
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: I want to compare and bring output to sheet2

    Thanks a lot. Working fine

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compare and Want to Bring output in Sheet 3
    By maddyrafi1987 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-26-2018, 10:32 AM
  2. [SOLVED] Can’t bring data over from sheet1 to sheet2 based on citeria
    By gz3s36 in forum Excel General
    Replies: 4
    Last Post: 02-03-2018, 12:19 PM
  3. [SOLVED] Lookup value from sheet1 in sheet2 to pull corresponding data and bring them to sheet 1
    By Xsample in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-01-2018, 08:53 AM
  4. Replies: 3
    Last Post: 09-24-2015, 08:20 AM
  5. Replies: 2
    Last Post: 09-27-2012, 01:19 PM
  6. Replies: 4
    Last Post: 09-04-2012, 03:23 PM
  7. compare Sheet2 against Sheet3 with highlighting results in Sheet2
    By mariposa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2011, 01:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1