Results 1 to 8 of 8

function that will aggregate selected data?

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2007
    Posts
    10

    function that will aggregate selected data?

    This forum has helped me a lot in the past. I tried searching and could not find an answer on this, and I fully admit that it could be because I'm using the wrong search terms. I will describe what I want to do as best I can.

    I want to have a list of characteristics which would lie in rows. For example:
    Has 4 legs.
    Has 2 eyes.
    Has fur.
    Has a tail.
    Has fins.


    Then I want to be able to select just the rows that apply to my "subject." Like this:

    x Has 4 legs.
    Has 2 eyes.
    x Has fur.
    x Has a tail.
    Has fins.

    In my mind, I would organize the characteristics in column B so that column A would be available to put an "x" next to the characteristics that apply to my subject.


    Finally--and this is where the formula comes in--I need a formula that will check the rows where I have placed an "x" and aggregate the corresponding characteristics into A SINGLE STRING. I feel that is the difference for what I'm trying to do and VLOOKUP. So, the formula would produce this string from my example:

    Has 4 legs. Has fur. Has a tail.


    Any ideas?
    Last edited by Eugene020202; 11-29-2014 at 05:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  2. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  3. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  4. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  5. Replies: 2
    Last Post: 03-20-2009, 01:29 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