Hi .. Newbie here so please excuse any terminology errors.
I have a simple excel spreadsheet with a worksheet specifically assigned to track our clients money coming in and out of the bank account. It works like this ;
08/04/08 Money In Mr D Smith £20,000
08/04/08 Money Out Mr D Smith £20,000
etc
I then have a pivot table running on a second spreadsheet that totals clients balances and the overall aggregated bank balance. This all works perfectly (although a little simplistic) and is accurate.
Here is the problem : If you take the example above, Mr D Smith's balance is 0.00 and gets reported in the pivot table. We now have a very messy pivot table (with hundreds of 0.00 entries) and need to remove all entries where client balances are 0.00 or return results <-£0.01 and >£0.01.
I have tried messing around with the 'null' value settings but I think this refers to empty cells. Assuming 0.00 is considered an amount and not empty?
Any suggestions (apart from setting it up properly in a database!!!)
Any help would be magic ..
Bookmarks