+ Reply to Thread
Results 1 to 14 of 14

Display rows from matching data

  1. 03-15-2024, 11:09 AM #1
    Zimmerray1
    Zimmerray1 is offline
    Registered User
    Join Date
    11-22-2013
    Location
    USA
    MS-Off Ver
    2003, 2007, 2010, Office 365
    Posts
    31

    Display rows from matching data

    I have data sets with hundreds of rows of data containing up to 10 columns. From my attachment, Column B (Batch) contains what I will call the identifiers. I have other identifiers in column A (PN) which contains hundreds more identifiers than column B. In my attached example, there are 20 identifiers in column A. There are only 9 matches in column B. I am needing to find the duplicates and return all the "Rows" on a different sheet.

    For clarity, I have applied conditional formatting to highlight the duplicates in column A & B. On sheet 2, I only want to return rows duplicated in column B.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-15-2024, 11:17 AM #2
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Display rows from matching data

    On sheet 2:

    =VSTACK(Sheet1!C3:H3,FILTER(Sheet1!B4:H18,ISNUMBER(MATCH(Sheet1!B4:B18,Sheet1!A4:A23,0))))
    Attached Files Attached Files
    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.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 03-15-2024, 11:21 AM #3
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Display rows from matching data

    Typo Alert!!

    =VSTACK(Sheet1!B3:H3,FILTER(Sheet1!B4:H18,ISNUMBER(MATCH(Sheet1!B4:B18,Sheet1!A4:A23,0))))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-15-2024, 01:48 PM #4
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,294

    Re: Display rows from matching data

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-18-2024, 08:46 AM #5
    Zimmerray1
    Zimmerray1 is offline
    Registered User
    Join Date
    11-22-2013
    Location
    USA
    MS-Off Ver
    2003, 2007, 2010, Office 365
    Posts
    31

    Re: Display rows from matching data

    @ Glenn -> I don't have VSTACK installed. I will turn in a ticket to help desk today and try to get it installed. Thanks
    Reply With QuoteRegister To Reply
  6. 03-18-2024, 09:00 AM #6
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Display rows from matching data

    It's available on 0365 from version 2208 onwards, if I remember correctly.
    Reply With QuoteRegister To Reply
  7. 03-18-2024, 12:08 PM #7
    Zimmerray1
    Zimmerray1 is offline
    Registered User
    Join Date
    11-22-2013
    Location
    USA
    MS-Off Ver
    2003, 2007, 2010, Office 365
    Posts
    31

    Re: Display rows from matching data

    Quote Originally Posted by Czeslaw View Post
    Power Query
    Please Login or Register  to view this content.
    Czeslaw, I am totally unfamiliar with Power Query. Where do I enter the code you have supplied? I know how to import data, but what do I do with it then?
    Reply With QuoteRegister To Reply
  8. 03-18-2024, 12:09 PM #8
    Zimmerray1
    Zimmerray1 is offline
    Registered User
    Join Date
    11-22-2013
    Location
    USA
    MS-Off Ver
    2003, 2007, 2010, Office 365
    Posts
    31

    Re: Display rows from matching data

    Quote Originally Posted by Glenn Kennedy View Post
    It's available on 0365 from version 2208 onwards, if I remember correctly.
    My company has "Addins" turned off.
    Reply With QuoteRegister To Reply
  9. 03-18-2024, 12:26 PM #9
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Display rows from matching data

    It's not an add-in. if you don't have vSTACK, it is because you are using a version of O365 that is now VERY out of date. It's an UPDATE to a more recent version (it was released in March 2022!!) that you need.

    Go to your accoutn page. What version does it show? it needs to be 2207 or 2208 (I can't remember which)or above...
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  10. 03-18-2024, 12:28 PM #10
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Display rows from matching data

    I just checked. VSTACK is in all versions from 2202 onwards. march 2022.
    Reply With QuoteRegister To Reply
  11. 03-18-2024, 12:53 PM #11
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Display rows from matching data

    So, if IT prefers that you continue to use an abacus, rather than the latest versions of O365, here is an equivalent that delivers the end result in two formulae.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 03-18-2024, 02:29 PM #12
    Zimmerray1
    Zimmerray1 is offline
    Registered User
    Join Date
    11-22-2013
    Location
    USA
    MS-Off Ver
    2003, 2007, 2010, Office 365
    Posts
    31

    Re: Display rows from matching data

    Here you go.
    Attachment 863222
    Reply With QuoteRegister To Reply
  13. 03-18-2024, 02:57 PM #13
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Display rows from matching data

    Oh. V2108. Almost prehistoric!! According to microsoft, you should now be on 2302 or 2308.

    1. What ahppens if you click on the updates button? Can you update?

    2. if not, ask your IT folk to UPDATE to the latest version that is compatible with your company's subscription.

    3. (easiest) Use the suggestion at Post 11.





    Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  14. 03-18-2024, 04:51 PM #14
    Zimmerray1
    Zimmerray1 is offline
    Registered User
    Join Date
    11-22-2013
    Location
    USA
    MS-Off Ver
    2003, 2007, 2010, Office 365
    Posts
    31

    Re: Display rows from matching data

    The filter function worked! Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to display a list rows with matching values from a second worksheet
    By imaquila in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2020, 02:44 AM
  2. Matching Data and if found pulling data from cell to the left of one of the matching rows
    By mpartyka in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2019, 11:57 PM
  3. [SOLVED] display matching data in new column
    By sarat47 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-03-2016, 09:33 AM
  4. [SOLVED] Display rows from multiple sheets matching a criteria
    By rudswa in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2015, 02:07 PM
  5. DIsplay data in sheet2 if ID are matching with sheet1
    By abraham30 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2013, 02:13 AM
  6. Matching Data between Files , Deleting Matching Rows
    By nem_vdoxx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-20-2013, 11:00 AM
  7. Matching Data in a Row and Display in Column
    By grizzly1733 in forum Excel General
    Replies: 3
    Last Post: 04-01-2006, 05:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1