+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Conditional filtering of multiple rows simultaniously

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Conditional filtering of multiple rows simultaniously

    Hey everyone,

    I'd like to take a spreadsheet that has multiple values across a row (think price based on different description values) and to only display the rows where at least one of the minimum price point conditions were met and export them to another sheet.

    For example:

    Baseball cards:

    Please Login or Register  to view this content.


    In this scenario, I would like to see only the values >$5 and have the results displayed in a new range or to a new sheet entirely while retaining the header rows and the data in the Player and Year columns also.

    Any help with this is greatly appreciated and will make my life a lot less stressful.

    Thanks in advance.
    Last edited by Spaceman56; 09-16-2011 at 11:26 AM. Reason: attempt to correct table formatting

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Conditional filtering of multiple rows simultaniously

    Spaceman56,

    Attached is an example workbook based on sample criteria you provided. It contains a button named Export which is assigned to the following macro:
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-16-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Conditional filtering of multiple rows simultaniously

    Wow, that is exactly what I was in need of!

    Thanks!

    Uh-oh....I just realized that I have a formatting issue that is killing the macro; Merged Cells!

    Is there a way of compensating for that? An example, going along with the current theme would be:

    Barry Bonds
    SF Giants

    Both the name and team are in a "single", merged cell.
    Last edited by Spaceman56; 09-16-2011 at 01:24 PM.

+ 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