The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024

Latest message you have seen: RE: Huf House


[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

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.