Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula in pivot tables involving counting text cells | Excel Worksheet Functions | |||
counting blank cells in a pivot table | Excel Discussion (Misc queries) | |||
pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions |