[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: 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
_____
Home |
Main Index |
Thread Index
|