Jan 23 2019 02:31 AM
Hi,
I am struggling to count a 'word' using Pivot table. I need to see the number of 'very important' across 5 different columns. I thought I could do this via pivot table but it doesn't seem to be showing me values. I am looking for a quick solution via Pivot rather than a filter and manually count as I will need to do this for a bigger excel document afterwards.
I am sure there is a very easy solution - if anyone could help I would be very grateful!
Thanks,
Mark
Jan 23 2019 03:37 AM
How about a formula like the attached ?
Jan 23 2019 03:46 AM
Jan 23 2019 03:49 AM