+ Reply to Thread
Results 1 to 3 of 3

compare two columns return info from a third but do not repeat

  1. #1
    Registered User
    Join Date
    10-30-2014
    Location
    anchorage, ak
    MS-Off Ver
    2007
    Posts
    1

    compare two columns return info from a third but do not repeat

    Hello, I have a difficult problem that I'm not sure has an answer. I have a table in the following format:

    name type rating cost selected
    A ab 10 20 0
    B ab 5 25 1
    C ac 7 7 0
    D ac 6 5 1
    E ac 8 17 1
    F ac 15 13 0
    G ad 14 9 0
    H ad 7 4 1
    I ad
    ...

    What I'm trying to do is create a summary of selected types in a separate area on the same sheet or a separate sheet. What the formula needs to do is look at the selected column for a "1" (this could also be yes/no) and match that with the type designation "ab" or "ac" or "ad" and return the name into a separate cell in the summary area of the sheet. My problem is, I cannot have repeated items. For example, I can have only one type of "ab", two types of "ac", three types of "ad", one type of "ae", one type of "af", and one type of "ag". For example, if an item has been selected ("1"), and it is of type "ac", I need a formula that returns the name of that individual. Then, when a different one of the same type has been selected ("1"), I need the cell below to indicate the name of that type, without repeating the name of the type above. Can this be accomplished or is it too difficult? I've attached the spreadsheet so you can see what I mean, thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: compare two columns return info from a third but do not repeat

    hi, Apply the below array formula

    Where

    G2=selected
    h2=TYPE


    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Boo?ath?

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: compare two columns return info from a third but do not repeat

    HI, ref the attachment
    Attached Files Attached Files

+ 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] Evaluate to columns; compare two columns and return result
    By kjxavier in forum Excel General
    Replies: 2
    Last Post: 09-25-2014, 04:08 AM
  2. Replies: 1
    Last Post: 04-21-2013, 08:36 AM
  3. columns to repeat info for price list
    By jp95 in forum Excel General
    Replies: 1
    Last Post: 12-09-2007, 06:36 PM
  4. Lookup, Compare and Return Info
    By NFJim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2007, 05:57 AM
  5. [SOLVED] compare columns of info
    By john mcmichael in forum Excel General
    Replies: 0
    Last Post: 08-19-2005, 03: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