+ Reply to Thread
Results 1 to 2 of 2

Formula to extracting columns values which fulfills criteria of other columns

Hybrid View

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    1

    Formula to extracting columns values which fulfills criteria of other columns

    Hallo,
    i am trying to find solution to generate a text (not list of column values) from all columns(starting from n) of row, which fulfills some criteria defined in other columns.See example.

    One row contatins data (Attribute) like payment, registration....., which can be extended or deleted.
    Other Rows contains value 1 or 0 in same column of attribute.
    Now i would like to display all attributes having 1 in other column. I have one formula but which is column specific like IF(C39=1;C3 & ",";"") & IF(D39=1;D3 & ",";"")..., so if i delete or add column i have to change
    it. I would like to have dynamic formula, which works without changing it for n columns.



    Service attributes
    payment registration pass. reset cloud marketing advertisement SSO
    Must 1 1 1 0 0 1 0
    Should 1 0 0 1 1 0 0
    Optional 0 0 0 0 0 0 1


    Result:

    Must payment,registration,pass. reset,advertisement
    Should payment,clould,marketing
    Optional SSO, cloud

    Any Help or tipps appreciated.

    Thanks
    SP
    Attached Files Attached Files
    Last edited by bholya; 04-03-2012 at 10:31 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Formula to extracting columns values which fulfills criteria of other columns

    See attached.
    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)

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