How to count "BLANK" cells in a pivot table

jayjavina

New Member
Joined
Feb 3, 2009
Messages
34
Hi,

Is there a way to count blank cells in a pivot table?

How about a formula to count blank cells too?

Thanks much and Merry Christmas! :biggrin:
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Are you interested in counting blank cells in only the data ranges? Is there a specific issue you are trying to tackle?
 
Upvote 0
Yes, i only want to count those in the data ranges. I dont have other issues its just i want the pivot table to count the blank cells.
 
Upvote 0
Does this work? Or are you trying to do something different? The blank cell is D15.

By Product-Customer

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 237px"><COL style="WIDTH: 94px"><COL style="WIDTH: 94px"><COL style="WIDTH: 94px"><COL style="WIDTH: 94px"><COL style="WIDTH: 72px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD> </TD><TD>Values</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD>Product</TD><TD>Sum of Qtr 1 </TD><TD>Sum of Qtr 2 </TD><TD>Sum of Qtr 3 </TD><TD>Sum of Qtr 4 </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: left">Alice Mutton</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: left">ANTON</TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ 702.00 </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: left">BERGS</TD><TD style="TEXT-ALIGN: right">$ 312.00 </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: left">BOLID</TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ 1,170.00 </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: left">ERNSH</TD><TD style="TEXT-ALIGN: right">$ 1,123.20 </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ 2,607.15 </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: left">GODOS</TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ 280.80 </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: left">HUNGC</TD><TD style="TEXT-ALIGN: right">$ 62.40 </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: left">PICCO</TD><TD style="TEXT-ALIGN: right">$ - </TD><TD style="TEXT-ALIGN: right">$ 1,560.00 </TD><TD> </TD><TD style="TEXT-ALIGN: right">$ - </TD><TD> </TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>F9</TD><TD>=COUNTBLANK(B9:E21)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1


EDIT: This is a pivot table. It just does not look it over here. Are you trying to use a formula that automatically detects the data range in the pivot without you selecting it? If yes, I'll have to think.
 
Upvote 0
Thanks for the help but, what i want is within the pivot table. Pivot table will be the one to count the blanks. I dont want to have a separate column to write down a formula to count the blanks.

i hope its possible in pivot tables.
 
Upvote 0
<title>Excel Jeanie HTML</title>Here is a sample A1:B13 is the data and from column D to H is the pivot table. How will i show the total number of blank cells in "(blank)" column in the pivot table?:confused:

Thanks!

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Century Gothic,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 146px;"> <col style="width: 64px;"> <col style="width: 64px;"> <col style="width: 95px;"> <col style="width: 120px;"> <col style="width: 57px;"> <col style="width: 55px;"> <col style="width: 84px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td> </td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td>Group Name</td> <td>Paid</td> <td> </td> <td>Count of Paid</td> <td>Column Labels</td> <td> </td> <td> </td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>TEAM A</td> <td>YES</td> <td> </td> <td>Row Labels</td> <td>NO</td> <td>YES</td> <td>(blank)</td> <td>Grand Total</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>TEAM B</td> <td> </td> <td> </td> <td style="text-align: left;">TEAM A</td> <td style="text-align: right;">1</td> <td style="text-align: right;">3</td> <td style="background-color: rgb(255, 255, 204);"> </td> <td style="text-align: right;">4</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>TEAM C</td> <td> </td> <td> </td> <td style="text-align: left;">TEAM B</td> <td> </td> <td> </td> <td style="background-color: rgb(255, 255, 204);"> </td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td>TEAM D</td> <td> </td> <td> </td> <td style="text-align: left;">TEAM C</td> <td> </td> <td> </td> <td style="background-color: rgb(255, 255, 204);"> </td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td>TEAM E</td> <td>YES</td> <td> </td> <td style="text-align: left;">TEAM D</td> <td style="text-align: right;">1</td> <td> </td> <td style="background-color: rgb(255, 255, 204);"> </td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td>TEAM A</td> <td>YES</td> <td> </td> <td style="text-align: left;">TEAM E</td> <td> </td> <td style="text-align: right;">1</td> <td style="background-color: rgb(255, 255, 204);"> </td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td> <td>TEAM A</td> <td>YES</td> <td> </td> <td style="text-align: left;">Grand Total</td> <td style="text-align: right;">2</td> <td style="text-align: right;">4</td> <td style="background-color: rgb(255, 255, 204);"> </td> <td style="text-align: right;">6</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td>TEAM A</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">10</td> <td>TEAM A</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">11</td> <td>TEAM B</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">12</td> <td>TEAM D</td> <td>NO</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">13</td> <td>TEAM A</td> <td>NO</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td></tr></tbody></table>

 
Upvote 0
You will have to insert a column into your data, say Paid2, and enter the formula shown. Paid2 will be used in the pivot table (shown in Columns L - P) in place of paid.

Would that work for you?

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:99px;" /><col style="width:117px;" /><col style="width:31px;" /><col style="width:44px;" /><col style="width:81px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td></tr><tr style="height:32px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-family:Verdana; font-size:10pt; ">Group Name</td><td style="font-family:Verdana; font-size:10pt; ">Paid</td><td style="font-family:Verdana; font-size:10pt; ">Paid2</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Count of Paid</td><td style="font-family:Verdana; font-size:10pt; ">Column Labels</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td >Count of Paid2</td><td >Column Labels</td><td > </td><td > </td><td > </td></tr><tr style="height:32px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:Verdana; font-size:10pt; ">TEAM A</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Row Labels</td><td style="font-family:Verdana; font-size:10pt; ">NO</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; ">(blank)</td><td style="font-family:Verdana; font-size:10pt; ">Grand Total</td><td > </td><td >Row Labels</td><td >NO</td><td >YES</td><td >Blank</td><td >Grand Total</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-family:Verdana; font-size:10pt; ">TEAM B</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Blank</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:left; ">TEAM A</td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">1</td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">3</td><td style="background-color:#ffffcc; font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">4</td><td > </td><td style="text-align:left; ">TEAM A</td><td style="text-align:right; ">1</td><td style="text-align:right; ">3</td><td style="text-align:right; ">2</td><td style="text-align:right; ">6</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:Verdana; font-size:10pt; ">TEAM C</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Blank</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:left; ">TEAM B</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="background-color:#ffffcc; font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td style="text-align:left; ">TEAM B</td><td > </td><td > </td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:Verdana; font-size:10pt; ">TEAM D</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Blank</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:left; ">TEAM C</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="background-color:#ffffcc; font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td style="text-align:left; ">TEAM C</td><td > </td><td > </td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:Verdana; font-size:10pt; ">TEAM E</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:left; ">TEAM D</td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">1</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="background-color:#ffffcc; font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">1</td><td > </td><td style="text-align:left; ">TEAM D</td><td style="text-align:right; ">1</td><td > </td><td style="text-align:right; ">1</td><td style="text-align:right; ">2</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-family:Verdana; font-size:10pt; ">TEAM A</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:left; ">TEAM E</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">1</td><td style="background-color:#ffffcc; font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">1</td><td > </td><td style="text-align:left; ">TEAM E</td><td > </td><td style="text-align:right; ">1</td><td > </td><td style="text-align:right; ">1</td></tr><tr style="height:32px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:Verdana; font-size:10pt; ">TEAM A</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; ">YES</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:left; ">Grand Total</td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">2</td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">4</td><td style="background-color:#ffffcc; font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; text-align:right; ">6</td><td > </td><td style="text-align:left; ">Grand Total</td><td style="text-align:right; ">2</td><td style="text-align:right; ">4</td><td style="text-align:right; ">6</td><td style="text-align:right; ">12</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-family:Verdana; font-size:10pt; ">TEAM A</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Blank</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:Verdana; font-size:10pt; ">TEAM A</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Blank</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:Verdana; font-size:10pt; ">TEAM B</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; ">Blank</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:Verdana; font-size:10pt; ">TEAM D</td><td style="font-family:Verdana; font-size:10pt; ">NO</td><td style="font-family:Verdana; font-size:10pt; ">NO</td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:Verdana; font-size:10pt; ">TEAM A</td><td style="font-family:Verdana; font-size:10pt; ">NO</td><td style="font-family:Verdana; font-size:10pt; ">NO</td><td style="font-family:Verdana; font-size:10pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=IF(ISBLANK<span style=' color:008000; '>(B2)</span>,"Blank",B2)</td></tr><tr><td >C3</td><td >=IF(ISBLANK<span style=' color:008000; '>(B3)</span>,"Blank",B3)</td></tr><tr><td >C4</td><td >=IF(ISBLANK<span style=' color:008000; '>(B4)</span>,"Blank",B4)</td></tr><tr><td >C5</td><td >=IF(ISBLANK<span style=' color:008000; '>(B5)</span>,"Blank",B5)</td></tr><tr><td >C6</td><td >=IF(ISBLANK<span style=' color:008000; '>(B6)</span>,"Blank",B6)</td></tr><tr><td >C7</td><td >=IF(ISBLANK<span style=' color:008000; '>(B7)</span>,"Blank",B7)</td></tr><tr><td >C8</td><td >=IF(ISBLANK<span style=' color:008000; '>(B8)</span>,"Blank",B8)</td></tr><tr><td >C9</td><td >=IF(ISBLANK<span style=' color:008000; '>(B9)</span>,"Blank",B9)</td></tr><tr><td >C10</td><td >=IF(ISBLANK<span style=' color:008000; '>(B10)</span>,"Blank",B10)</td></tr><tr><td >C11</td><td >=IF(ISBLANK<span style=' color:008000; '>(B11)</span>,"Blank",B11)</td></tr><tr><td >C12</td><td >=IF(ISBLANK<span style=' color:008000; '>(B12)</span>,"Blank",B12)</td></tr><tr><td >C13</td><td >=IF(ISBLANK<span style=' color:008000; '>(B13)</span>,"Blank",B13)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1
 
Upvote 0
Thanks for the idea (y)!

I just inserted another column in the data table and hid it so that it wont show to the users.

I hope it fail me in the pivot table.
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,027
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top