+ Reply to Thread
Results 1 to 2 of 2

IF STATEMENT - must be a simpler way

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    gray
    MS-Off Ver
    excel 2007
    Posts
    52

    IF STATEMENT - must be a simpler way

    I have created this very simple sample spreadsheet that shows what I am trying to do with 1,000s of records.

    We import data with hundreds of 00 value entries. We then create a template report where we want to list only those items with positive values.... I want to pull both the list and the values without all the blank spaces.

    the raw data I am really working with has 25 categories, 1,200 line items, and about 400 postive value items.

    Any help with simplifying the report would be appreciated. I use a complex If/vlookup/sumif functions for other parts of this report, but this simple listing has created more problems for me - I spend most of my time doing this manually.

    Tx. Terri
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,675

    Re: IF STATEMENT - must be a simpler way

    Do you need to show every individual transaction in your report, or sum them by combination of building and sales category? If you need sums then a pivot table is the best solution.

    If you need to show each transaction then can you just apply an autofilter to filter out the 0 values, and then sort by the appropriate columns?

    If it really, really has to be in the report format you showed then it will be a bit more work.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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