+ Reply to Thread
Results 1 to 3 of 3

Copy if function?

  1. #1
    Registered User
    Join Date
    03-15-2012
    Location
    NM, USA
    MS-Off Ver
    Excel 2007
    Posts
    8

    Copy if function?

    Hi everyone, is it possible to do a copy if function? I have a table consisting of several giant columns of data. I want to copy the dividend and volatility columns, but ONLY IF the volatility column has a value greater than 0. So for example, if the dividends are column H and the volatility is column I, and cell I5 has a value of 0, then it will not copy over H5 or I5, regardless of what the corresponding value in H5 is. Likewise, if cell I5 has any value greater than 0, it will copy both the values of H5 and I5, regardless of the value in H5. Additionally, can it be done so that there are not huge gaps between the data? I've read something about using a combination of MATCH and OFFSET functions, but I have no idea what these functions are or if they could even work. Does anybody know how it might be possible to do this?

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

    Re: Copy if function?

    Please provide a sample of what it should look like before and after.

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copy if function?

    Sounds like you just need to do an AUTOFILTER on this data. Turn on the DATA > TABLE (AutoFilter) and apply a Custom filter to column I to show only values > 0. Then just copy columns H:I to another sheet while it's filtered.

    Some people find the Filtered data is fine where it is, you can edit/print/format the filtered data, then turn the filter off when done without ever really needing a second sheet.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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