+ Reply to Thread
Results 1 to 3 of 3

How to extract data with criteria from another sheet and list it.

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    PH
    MS-Off Ver
    2013
    Posts
    31

    Exclamation How to extract data with criteria from another sheet and list it.

    I have a list of data in sheet 2. Now on sheet 1, i need to list down data based on the criteria i want from sheet 2. How can i do this?

    Thanks in advanced!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to extract data with criteria from another sheet and list it.

    Sounds like you want something like this...

    Lookup with multiple instances of the lookup value
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    06-18-2014
    Location
    PH
    MS-Off Ver
    2013
    Posts
    31

    Re: How to extract data with criteria from another sheet and list it.

    Thank! will check it out

+ 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. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  2. Extract Data from one sheet to another based on criteria
    By alghareeb in forum Excel General
    Replies: 1
    Last Post: 05-08-2013, 09:16 AM
  3. Replies: 11
    Last Post: 07-11-2012, 06:08 PM
  4. Replies: 2
    Last Post: 03-23-2011, 06:19 PM
  5. How can I extract data from a list that meets certain criteria?
    By fsimek in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2008, 04:20 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