+ Reply to Thread
Results 1 to 11 of 11

Get all matching data

  1. #1
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Get all matching data

    Hi how would i go about getting all data that matches if i want to cross reference 2 sheets, for example if sheet1 and sheet2 had data on and i wanted to filter all data that matched the word "hello" to sheet3, how would i do this? im using google excel. Thanks

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Get all matching data

    im using google excel...
    Google do not own Excel...

  3. #3
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Get all matching data

    google sheets sorry

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Get all matching data

    I've never used Google Sheets so cannot comment - perhaps someone who has will happen along but it is an Excel forum, after all.

    Perhaps a dedicated Google Sheets forum might be better for you.

  5. #5
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Get all matching data

    well i always used this one as at the top it says For Other Platforms(Mac, Google Docs, Mobile OS etc) and as google docs is in there i just assumed google sheets would come under this.

  6. #6
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Get all matching data

    the functions are not far off normal excel, so if i know how that works i might be able to work it out. but thanks anyway

  7. #7
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Get all matching data

    Very true... I viewed your post from the 'New Posts' page - Didn't notice the category. Ignore me

  8. #8
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Get all matching data

    if anyone can help here is a example data, so i want to output sheet1 and sheet2 into sheet3 with all data that matches the word "hello" so if it matches "hello" it will output that data in row a,b,c,d,e,f to sheet3

    https://docs.google.com/spreadsheets...it?usp=sharing

  9. #9
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,580

    Re: Get all matching data

    Take a look at this thread from yesterday:

    http://www.excelforum.com/excel-form...-a-master.html

    It does exactly the same as what you are asking for.

    Hope this helps.

    Pete

  10. #10
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Get all matching data

    Thanks allot this helped allot pete_uk, had to mod it a little to work as i need it to but it did the job, thanks for searching and helping.

  11. #11
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,580

    Re: Get all matching data

    Hey, thanks for the rep, Ditch.

    I downloaded your Google doc into Excel earlier and set it up for you. Here's the result.

    Cheers,

    Pete
    Attached Files Attached Files

+ 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. [SOLVED] Matching two tables, copying data for matching value
    By Gatis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2014, 07:51 PM
  2. copy matching and non-matching data into new worksheet
    By sarat47 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2014, 12:19 PM
  3. Replies: 5
    Last Post: 01-31-2014, 09:59 AM
  4. Finding Matching Data in one Column/Adding corresponding matching string value.
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2013, 07:23 PM
  5. Indexing and matching data from date range and matching
    By Rickomicko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2013, 11:46 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. Replies: 2
    Last Post: 04-18-2013, 05:56 PM
  8. SQL Query to get count of matching & non-matching data from two tables
    By Kiran2012 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 10:32 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