Forum Discussion
Solved
Excel pivot table help @members
Hi i would wanna ask how do you count the names with the table below? Because i have to show a column where which topic is more people prefer. Like how do i turn counting names to number and sum it?...
pan-g I replicated a small part of your table and used Power Query to extract and count the names per Topic.
See if this does what you had in mind. File attached.
Missed that you have several lines in one range. I think this works:
=COUNTA(TEXTSPLIT(TEXTJOIN(E2,F2,G2,H2,I2),CHAR(10)))
---
Updates:
=COUNTA(TEXTSPLIT(TEXTJOIN(CHAR(10),TRUE,E2,F2,G2,H2,I2),CHAR(10)))
XXplore Well, I can assure you that it does not!
- I3=COUNTA(TEXTSPLIT(TEXTJOIN(CHAR(10),TRUE,Table1[@Bus],Table1[@Sci],Table1[@Med],Table1[@Psy],Table1[@Eng]),CHAR(10)))