Results 1 to 4 of 4

Sort table B by Table A's IDs

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Sort table B by Table A's IDs

    Hello

    Simple question for you. I have two tables - Table A and Table B. Table A has just a few entries in it while Table B has a much larger data set (including all of the entries in Table A). I want to filter Table B to just show me the rows that match Table A's items. What is the best way to go about doing this?

    This is a dumbed down version of an exercise I need to do. A VLOOKUP or any kind of searching won't work. I need to filter Table B in place.

    I've actually found a way to do this by using the advanced filter, but since in my data set Table A has 350 rows and Table B has 5,000+ rows it's just a little inconvenient to add a ton of rows above Table B and advanced filter that way.

    See attached for example

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sort volumes from a random table to a new Table.
    By omega0010 in forum Excel General
    Replies: 8
    Last Post: 08-15-2014, 04:29 PM
  2. [SOLVED] Look at column in table, remove duplicates and sort to another table
    By pdx-adm-trm01 in forum Excel General
    Replies: 1
    Last Post: 03-19-2014, 06:56 PM
  3. Re-sort table without affecting original table?
    By jfrog in forum Excel General
    Replies: 1
    Last Post: 01-30-2013, 01:19 PM
  4. [SOLVED] Need a formula to sort a table into table (for a Table Plan) and name in column 2
    By jbpianoman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2012, 09:21 AM
  5. Sort table with only formulas...and not pivot table
    By agweyre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2012, 09:19 PM
  6. Replies: 2
    Last Post: 05-19-2010, 05:14 AM
  7. [SOLVED] pivot table sort entries that don't yet appear in table
    By rachael in forum Excel General
    Replies: 11
    Last Post: 09-19-2005, 07:05 PM

Tags for this Thread

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