+ Reply to Thread
Results 1 to 5 of 5

Help me filter this table please!

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Help me filter this table please!

    Help me filter from 1st table to 2nd table, step to step, thank you very much!
    \1
    Attached Images Attached Images
    Last edited by huycuopbien123; 05-13-2014 at 07:42 AM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Help me filter this table please!

    You need a bit more explanation.....
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help me filter this table please!

    i mean how to arrange the "name" and "class" in the first table into the second table that fits to the "code"
    Last edited by huycuopbien123; 05-13-2014 at 11:38 AM.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Help me filter this table please!

    In B10

    =VLOOKUP($A10,$A$1:$C$5,COLUMN(B$1),False)

    and copy down and across. But your example does not have the same values, so some cells may be errors.

  5. #5
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help me filter this table please!

    thank you man but i dont know why some values are different, this is the excercise the recruiter asked me in the interview and i couldnt resolve it
    Last edited by huycuopbien123; 05-13-2014 at 12:13 PM.

+ 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] Filter Table as i type in textbox1 but when erasing the text filter should be unfilter
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2014, 09:08 AM
  2. Replies: 1
    Last Post: 02-07-2014, 03:12 AM
  3. Replies: 1
    Last Post: 02-07-2014, 03:04 AM
  4. [SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  5. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM

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