RE: OT: Excel Pivottables

["Rob Mouser" <groups@xxxxxxx>]

Thanks Pete

Aren't pivottables fun (NOT!) I use them a fair bit but was trying to
create
something a little more complex to analyze 14mb worth of invoice data(Some
50,000+lines.) I was trying to avoid inserting additional columns in the
source data as the whole idea was to have a fairly automated report, just
updating the pivot table when more data was added.
Guess I'm going to have to dive in and dust of my VERY dated and VERY VERY
limited VBA knowledge so I can automatically add the required
columns/additional info into the source data.

Hohum....

Rob

-----Original Message-----
From: White, Peter [mailto:peter.white@xxxxxxx]
Sent: 20 January 2004 23:06
To: ukha_d@yahoogroups.com
Subject: RE: [ukha_d] OT: Excel Pivottables

I've been using Excel for yonks, but only did my first pivot tables
yesterday, all by trial and error.  If you don't get a more sensible
answer,
I would just add another column into the source spreadsheet, with something
like =if(a1="","Blank",a1), so as far as your pivot is
concerned, it's still
counting the blanks, if in a slightly yee-haa way.

Pete

-----Original Message-----
From: Rob Mouser [mailto:groups@xxxxxxx]
Sent: 20 January 2004 21:52
To: ukha_d@yahoogroups.com
Subject: [ukha_d] OT: Excel Pivottables


Hi All



I'm sorry for the OT but I'm beginning to go stir crazy! I want to add a
calculated field to a pivot table in Excel. Specifically I want to count
blank cells in a range of data. I can do this no problem using COUTBLANK or
COUNTA or other formulas in a spread sheet but when I try and use in a
calculated field I either get a message saying my formula is invalid, which
it isn't or it returns a value of 1 which is incorrect.



Do we have any Excel Gurus who could contact me off list and put me out of
my misery :-( ?



Thanks in advance



Rob



[Non-text portions of this message have been removed]



UK Home Automation Meet 2004 - BOOK NOW!
http://www.ukha2004.com <http://www.ukha2004.com>

http://www.automatedhome.co.uk
<http://www.automatedhome.co.uk>
Post message: ukha_d@yahoogroups.com
Subscribe:  ukha_d-subscribe@yahoogroups.com
Unsubscribe:  ukha_d-unsubscribe@yahoogroups.com
List owner:  ukha_d-owner@yahoogroups.com



_____