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
Bookmarks