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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.