Results 1 to 4 of 4

Retrieving Data that meets a certian criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Retrieving Data that meets a certian criteria

    Hello,

    I am trying to use a function that will retrieve data in the same order specified, for a certain criteria. The following is an example of what I am trying to accomplish:

    The DATA:
    Car Acc.
    1 10
    1 20
    1 30
    1 40
    1 50
    2 12
    2 15
    2 20
    2 22
    3 11
    3 12
    3 17
    3 19
    3 21
    4 20
    4 22
    4 26
    4 21

    The table I am trying to produce:

    _1 _2 _3 _4
    10 12 11 20
    20 15 12 22
    30 20 17 26
    40 22 19 21
    50 21

    Many Thanks
    Last edited by Otaishtf; 08-26-2013 at 01:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. problem with tip "Retrieving an Item from a List that Meets Multiple Criteria"
    By filoberto in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 1
    Last Post: 02-25-2006, 08:15 PM
  2. Retrieving an Item from a List that Meets Multiple Criteria
    By hgopp99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2006, 11:10 AM
  3. Replies: 3
    Last Post: 01-02-2006, 10:30 AM
  4. Retrieving an Item from a List that Meets Multiple Criteria
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 03:00 AM
  5. Retrieving an Item from a List that Meets Multiple Criteria
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 02:59 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