+ Reply to Thread
Results 1 to 4 of 4

Extract Data & Ignore Conditions

  1. #1
    Forum Contributor
    Join Date
    10-09-2010
    Location
    London
    MS-Off Ver
    Excel Version Office 365
    Posts
    203

    Extract Data & Ignore Conditions

    Hi

    I have attached a file with an explanation.

    Require a formulae that states:
    If there is no number or CTA column is zero, we take the pipeline number x multiplier to get adj.

    If there is a CTA number (which is negative), we ignore the pipeline number and take the CTA number x multiplier = adj. but this must be converted to a positive number

    Any help will be appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Extract Data & Ignore Conditions

    Try this in F2 and drag down:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-09-2010
    Location
    London
    MS-Off Ver
    Excel Version Office 365
    Posts
    203

    Re: Extract Data & Ignore Conditions

    Thanks Melvosh

    Another great solution by you.

  4. #4
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Extract Data & Ignore Conditions

    Thanks, always happy to help.

+ 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] Extract data based on table of conditions
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-06-2015, 01:32 PM
  2. Replies: 2
    Last Post: 10-16-2014, 11:35 AM
  3. [SOLVED] Extract Data from one to another using conditions
    By missy22 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-26-2014, 07:36 AM
  4. Extract the data to another sheet based on variable conditions
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-25-2014, 06:10 PM
  5. [SOLVED] help with VBA codes to extract selected data from worksheet on specific conditions
    By HarryC in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-10-2013, 06:29 AM
  6. Extract Data based on conditions on multiple columns
    By checkoncomp in forum Excel General
    Replies: 6
    Last Post: 07-03-2013, 01:54 PM
  7. Replies: 2
    Last Post: 06-01-2012, 09:24 AM

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