+ Reply to Thread
Results 1 to 3 of 3

Need Help with Very Difficult =IF Statement

  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    Cincinnati, Ohio
    MS-Off Ver
    2010
    Posts
    10

    Need Help with Very Difficult =IF Statement

    I am collecting data in a survey that comes back looking like the below...I need help writing a formula that will make it isolate and pull out only the value that is True.

    What I have:
    {Fluid Milk-Shelving : true, Fluid Milk-Bossie : false, Fluid Milk-Milk Mover : false, }


    What I need:
    Fluid Milk-Shelving


    Would also love help with finding a way to separate multiple of these segments from one cell using some sort of text to columns.

    The attachment is pretty vanilla, no real data here except you can tell we're doing something for a grocery store.

    Any help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Need Help with Very Difficult =IF Statement

    Is that what you want?
    (add-in for Ex2010 - PowerQuery is required if you want do something with this)
    Attached Files Attached Files
    Last edited by sandy666; 11-03-2017 at 04:34 PM.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,609

    Re: Need Help with Very Difficult =IF Statement

    macro to return parts to adjacent cell (col g)
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

+ 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. Replies: 2
    Last Post: 12-20-2013, 12:12 AM
  2. If statement (difficult)
    By amartino44 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-16-2013, 04:52 AM
  3. [SOLVED] Semi Difficult IF Statement - please help :S
    By pwall1115 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2013, 10:26 PM
  4. Help, too difficult for me.
    By Menno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2006, 09:53 AM
  5. Too difficult for me, please help.
    By Menno in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2005, 09:01 AM
  6. Ok I have to be difficult
    By Dominique Feteau in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2005, 01:05 PM
  7. Please help! I can't believe this is so difficult:-)
    By philip.langley@ in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 08:19 PM
  8. Difficult if statement need help
    By nicoleeee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2005, 01:36 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