+ Reply to Thread
Results 1 to 3 of 3

Function newbie

  1. #1
    Registered User
    Join Date
    05-02-2008
    Posts
    4

    Function newbie

    Hi,

    While i'm comfortable with excel, I don't know some of the common workarounds, and while I've found some solutions that may fit here, there wasn't any accompanying description so I thought i'd post something new.

    What I need is to have a function which will match something from one column and return a value from another.

    I have been using index & match to do this - but it does not handle duplicates. I will have many, legitimate duplicates, and I require them to show up as well.

    My basic need is this. I have 3 columns to check and order. Each ordered list (1 for each column) will also have to reference the correct value from the 1st column.

    So lets say steve and bob both have a value of '4'. In the list that compiles that column, I would need both steve and bob to be represented. My current setup of index & match will show the two '4' values (I use large()), but will only match the first name it finds.

    If the formula is long I would appreciate if you explained it so I will be able to mold it to my needs.

    My current function is : =INDEX(A:A,MATCH(LARGE(B:B,ROW()-1),B:B))

    thanks for your help

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Hello, adam,

    Please read the Forum Rules about thread titles and amend your thread title accordingly.

  3. #3
    Registered User
    Join Date
    05-02-2008
    Posts
    4
    I would love to, but I cannot seem to edit the title.

    Can you just delete this thread and I'll re-post in the excel function subforum?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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