Results 1 to 5 of 5

Excel 2007 : Join multiple field and ignore blank/false fields

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2011
    Location
    East Alton, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    6

    Join multiple field and ignore blank/false fields

    If I have a list of cells that are based on a control form that result in a true or false outcome. And I want to list only those items that are true in a sentence. Example

    Example of table

    Stoke True
    Cancer True
    Smoker False

    Example of desired outcome:

    John has a medical history of: Stoke, Cancer.

    I can use the concantante function, but it put's "," in between all cells even if they are false.
    Attached Files Attached Files
    Last edited by Teresa; 10-07-2011 at 10:33 AM.

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