Pivot Tables--Counting Blank Cells
 

HI,

I have a similar data type as below

name p/n data to sent y/n response received y/n meet
requirements y/n
john a y y
john b
john c y
john d y y
y
john e n

When I create a pivot table I need the following:

name data sent y data sent n blanks
john 3 1 1

Please advise on how to create.
Thanks

Pivot Tables--Counting Blank Cells
 

Create a pivot table with Name in the row area, Date Sent in the Column
area, and Data Sent in the Data area, as count of Data Sent.
In the pivot table, select the (blanks) heading, and type blanks.

CrimsonPlague29 wrote:
HI,

I have a similar data type as below

name p/n data to sent y/n response received y/n meet
requirements y/n
john a y y
john b
john c y
john d y y
y
john e n

When I create a pivot table I need the following:

name data sent y data sent n blanks
john 3 1 1

Please advise on how to create.
Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Tables--Counting Blank Cells
 

Hi
You cannot get a count of blank, as there is nothing to count.
Add another column to your source data in column F called Count with a
formula in F2 of
=IF(C2="y","y",IF(C2="n","n","b"))
Copy down for the extent of your data.
Then with your PT, drag Name to the Row area
Drag Count to the Column area
Drag Count again to the data area


--
Regards

Roger Govier


"CrimsonPlague29" wrote in
message ...
HI,

I have a similar data type as below

name p/n data to sent y/n response received y/n meet
requirements y/n
john a y y
john b
john c y
john d y y
y
john e n

When I create a pivot table I need the following:

name data sent y data sent n blanks
john 3 1 1

Please advise on how to create.
Thanks