Help me Excel Community

[drowsyacorn]

Hey Team,

I've developed a dashboard but have come across one error and I am hoping someone out there can help me!

By using VBA code, I have columns which allows for multiple items in a drop-down list e.g. column A has the option to select Apple, Orange, Banana.

Is there a way to produce a pivot table which reads and counts each option individually?

*currently counts as apple, orange, banana = 1
*want it to count as:
*apple = 2
*orange = 1
*banana = 4 etc.

Please help!

 

[SpillerBD]

Your data needs to be known....
But COUNT is one of the simple calculation options.

 

[drowsyacorn]

Ughhh. I'm so new to this forum I cannot find the simple icon to attach the data.

Cannot use count if because i need the output to be in pivot table form so the table changes in my dashboard when using splicers.

 

[Michael M]

You can't "attach" files in this forum.
I'd suggest looking at available options here

https://www.mrexcel.com/forum/about-board/508133-attachments.html

OR
Upload your file to a sharing site ( Dropbox) for instance and then post the link back here