How can I get a count of columns in a pivot table data area (without VBA)?
I am a newbie, so please bear with me!
My pivot table expands/contracts horizontally when filters are applied.
When you select anything from the slicer, the number of columns changes. I need a count of the number of generated data columns.
How can I get a count of columns that have been generated in the data area of the pivot table (without VBA)?
A thousand thanks in advance!
Last edited by Agrajag909; 01-09-2022 at 09:40 AM.
Please see the yellow banner at the top of the page.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You want me to pay for some help? I thought this was forum for people to help each other.
Disappointed.
NO!
Trevor is referring to the other banner - he wants you to provide a sample workbook.
Last edited by AliGW; 01-09-2022 at 06:47 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you, AliGW, but it isn't a complicated question and I don't see how providing a simple pivot table will help. I just need to find out how to get a column count from a pivot table displaying data (without VBA).
Do you know how this number can be obtained?
I would also have asked for a sample workbook. I can't answer your question as it stands without seeing your pivot table - sorry.
I don't see that it's hard for you to provide a workbook. You are the one asking for help, so really should be guided by those offering to help you.
Ok, thank you. I have uploaded a sample workbook!
This maybe?
=COUNTIF(D6:L6,"<>")+2
Maybe:Formula:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks