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