Count of blank values in Pivot table

[Chandrasheka]

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]

All you have given us is data, no pivot, no explanation as to what you mean.

[Chandrasheka]

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]

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]

It seems that blanks just don't count. Replace them with a space, and it counts 2 as you want.

[Chandrasheka]

Hi,

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

Thanks

Chandra Shekar