PDA

View Full Version : Count of blank values in Pivot table



Chandrasheka
11-09-2010, 07:58 AM
Hi,

I am not getting count of blank cell in column B. Please chk the vba code if any suggestion pls let me know.

Thanks

Chandra Shekar

Bob Phillips
11-09-2010, 08:28 AM
All you have given us is data, no pivot, no explanation as to what you mean.

Chandrasheka
11-09-2010, 08:50 AM
Hi XLD,

I have a vba code if u run it pivot table will generate in sheet3.
In column B I have blank cell and I have value Others in Column C. I need count as 2 for others.


A B C


2
b/2
b
5
e/5
e
12

Others
1
a/1
a
7
g/7
g
13

Others

Chandrasheka
11-09-2010, 08:53 AM
Sorry Could not able to paste data properly

I have blank cell is Column B : Cell B13 and I have Value Others in Column C : Cell C13 same as Column B : Cell B16 and value as other in Cell C16. I need count as 2 for others. which is not getting by vba code.

Thanks in advance

Regards,

Chandra Shekar

Bob Phillips
11-09-2010, 08:58 AM
It seems that blanks just don't count. Replace them with a space, and it counts 2 as you want.

Chandrasheka
11-09-2010, 09:03 AM
Hi,

Thank you for your suggestion in urgent I could not able to give much detail sorry for that.

Thanks

Chandra Shekar