Posted to microsoft.public.excel.worksheet.functions

carl

Posts: n/a

PivotTable Question

I have a large database that looks like this:

Date Time New Price
20060314 95511 -0.4
20060314 95513 1
20060314 95518 -0.2
20060314 95531 2.25
20060314 95533 0.75
20060314 95536 0.55

Can the Pivot Table Function count the instance where New Price is less than
zero for a given day ?

Thank you in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PivotTable Question	RJMAT	Excel Discussion (Misc queries)	0	May 2nd 06 01:50 PM
QUESTION: Copy pivottable from excel file to another.	Simon	Excel Discussion (Misc queries)	0	April 26th 06 10:48 AM
PivotTable Question	j_cavanagh	Excel Discussion (Misc queries)	6	April 13th 06 10:43 PM
Dynamic parameterized PivotTable update?	Nick Keller	Excel Discussion (Misc queries)	0	February 24th 06 11:02 PM
PivotTable question	Peter Aitken	Excel Discussion (Misc queries)	1	July 1st 05 06:53 PM

All times are GMT +1. The time now is 07:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us